﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ControleAtivoDataSet" targetNamespace="http://tempuri.org/ControleAtivoDataSet.xsd" xmlns:mstns="http://tempuri.org/ControleAtivoDataSet.xsd" xmlns="http://tempuri.org/ControleAtivoDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ControleAtivoConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ControleAtivoConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ControleEstoque.Entidades.Properties.Settings.GlobalReference.Default.ControleAtivoConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsuarioTableAdapter" GeneratorDataComponentClassName="UsuarioTableAdapter" Name="Usuario" UserDataComponentName="UsuarioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.Usuario" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Usuario] WHERE (([UsuarioId] = @Original_UsuarioId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UsuarioId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UsuarioId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Usuario] ([UsuarioNome], [UsuarioMatricula], [UsuarioSenha], [UsuarioTipo], [UsuarioEmail]) VALUES (@UsuarioNome, @UsuarioMatricula, @UsuarioSenha, @UsuarioTipo, @UsuarioEmail)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UsuarioNome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UsuarioNome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UsuarioMatricula" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UsuarioMatricula" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UsuarioSenha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UsuarioSenha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UsuarioTipo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UsuarioTipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UsuarioEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UsuarioEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     UsuarioId, UsuarioNome, UsuarioMatricula, UsuarioSenha, UsuarioTipo, UsuarioEmail
FROM         Usuario</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Usuario] SET [UsuarioNome] = @UsuarioNome, [UsuarioMatricula] = @UsuarioMatricula, [UsuarioSenha] = @UsuarioSenha, [UsuarioTipo] = @UsuarioTipo, [UsuarioEmail] = @UsuarioEmail WHERE (([UsuarioId] = @Original_UsuarioId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UsuarioNome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UsuarioNome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UsuarioMatricula" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UsuarioMatricula" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UsuarioSenha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UsuarioSenha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UsuarioTipo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UsuarioTipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UsuarioEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UsuarioEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UsuarioId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UsuarioId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UsuarioId" DataSetColumn="UsuarioId" />
              <Mapping SourceColumn="UsuarioNome" DataSetColumn="UsuarioNome" />
              <Mapping SourceColumn="UsuarioMatricula" DataSetColumn="UsuarioMatricula" />
              <Mapping SourceColumn="UsuarioSenha" DataSetColumn="UsuarioSenha" />
              <Mapping SourceColumn="UsuarioTipo" DataSetColumn="UsuarioTipo" />
              <Mapping SourceColumn="UsuarioEmail" DataSetColumn="UsuarioEmail" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.Usuario" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUsuarioTipo" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUsuarioTipo" GeneratorSourceName="FillByUsuarioTipo" GetMethodModifier="Public" GetMethodName="GetDataByUsuarioTipo" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUsuarioTipo" UserSourceName="FillByUsuarioTipo">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     UsuarioEmail, UsuarioId, UsuarioMatricula, UsuarioNome, UsuarioSenha, UsuarioTipo
FROM         Usuario
WHERE     (UsuarioTipo = @usuarioTipo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="usuarioTipo" ColumnName="UsuarioTipo" DataSourceName="ControleAtivo.dbo.Usuario" DataTypeServer="char(1)" DbType="AnsiString" Direction="Input" ParameterName="@usuarioTipo" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="UsuarioTipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.Usuario" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="VerificarUsuarioSenha" GetMethodModifier="Public" GetMethodName="VerificarUsuarioSenha" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="VerificarUsuarioSenha" UserSourceName="VerificarUsuarioSenha">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     UsuarioId, UsuarioNome, UsuarioMatricula, UsuarioSenha, UsuarioTipo, UsuarioEmail
FROM         Usuario
WHERE     (UsuarioMatricula = @usuarioMatricula) AND (binary_checksum(UsuarioSenha) = binary_checksum(@usuarioSenha))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="usuarioMatricula" ColumnName="UsuarioMatricula" DataSourceName="ControleAtivo.dbo.Usuario" DataTypeServer="varchar(15)" DbType="AnsiString" Direction="Input" ParameterName="@usuarioMatricula" Precision="0" ProviderType="VarChar" Scale="0" Size="15" SourceColumn="UsuarioMatricula" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="usuarioSenha" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@usuarioSenha" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AtivoTableAdapter" GeneratorDataComponentClassName="AtivoTableAdapter" Name="Ativo" UserDataComponentName="AtivoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.Ativo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Ativo] WHERE (([AtivoId] = @Original_AtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Ativo] ([TipoAtivoId], [FabricanteAtivoId], [AtivoNome], [AtivoRFID]) VALUES (@TipoAtivoId, @FabricanteAtivoId, @AtivoNome, @AtivoRFID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TipoAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoAtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FabricanteAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FabricanteAtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AtivoNome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AtivoNome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AtivoRFID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AtivoRFID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AtivoId, TipoAtivoId, FabricanteAtivoId, AtivoNome, AtivoRFID FROM dbo.Ativo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Ativo] SET [TipoAtivoId] = @TipoAtivoId, [FabricanteAtivoId] = @FabricanteAtivoId, [AtivoNome] = @AtivoNome, [AtivoRFID] = @AtivoRFID WHERE (([AtivoId] = @Original_AtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TipoAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoAtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FabricanteAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FabricanteAtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AtivoNome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AtivoNome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AtivoRFID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AtivoRFID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AtivoId" DataSetColumn="AtivoId" />
              <Mapping SourceColumn="TipoAtivoId" DataSetColumn="TipoAtivoId" />
              <Mapping SourceColumn="FabricanteAtivoId" DataSetColumn="FabricanteAtivoId" />
              <Mapping SourceColumn="AtivoNome" DataSetColumn="AtivoNome" />
              <Mapping SourceColumn="AtivoRFID" DataSetColumn="AtivoRFID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillWithFabricanteAtivoNomeAndTipoAtivoNome" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataWithFabricanteAtivoNomeAndTipoAtivoNome" GeneratorSourceName="FillWithFabricanteAtivoNomeAndTipoAtivoNome" GetMethodModifier="Public" GetMethodName="GetDataWithFabricanteAtivoNomeAndTipoAtivoNome" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataWithFabricanteAtivoNomeAndTipoAtivoNome" UserSourceName="FillWithFabricanteAtivoNomeAndTipoAtivoNome">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Ativo.AtivoId, Ativo.TipoAtivoId, Ativo.FabricanteAtivoId, Ativo.AtivoNome, Ativo.AtivoRFID, FabricanteAtivo.FabricanteAtivoNome, 
                      TipoAtivo.TipoAtivoNome
FROM         Ativo INNER JOIN
                      FabricanteAtivo ON Ativo.FabricanteAtivoId = FabricanteAtivo.FabricanteAtivoId INNER JOIN
                      TipoAtivo ON Ativo.TipoAtivoId = TipoAtivo.TipoAtivoId</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.Ativo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillWithNoEstoque" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataWithNoEstoque" GeneratorSourceName="FillWithNoEstoque" GetMethodModifier="Public" GetMethodName="GetDataWithNoEstoque" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataWithNoEstoque" UserSourceName="FillWithNoEstoque">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     AtivoId, TipoAtivoId, FabricanteAtivoId, AtivoNome, AtivoRFID
FROM         Ativo
WHERE     (TipoAtivoId = @tipoAtivoId) AND (FabricanteAtivoId = @fabricanteAtivoId) AND (NOT EXISTS
                          (SELECT     LocalArmazenagemId, AtivoId, EstoqueAtual, EstoqueMinimo
                            FROM          Estoque
                            WHERE      (AtivoId = Ativo.AtivoId) AND (LocalArmazenagemId = @localArmazenagemId))) OR
                      (TipoAtivoId = @tipoAtivoId) AND (@fabricanteAtivoId IS NULL) AND (NOT EXISTS
                          (SELECT     LocalArmazenagemId, AtivoId, EstoqueAtual, EstoqueMinimo
                            FROM          Estoque AS Estoque_3
                            WHERE      (AtivoId = Ativo.AtivoId) AND (LocalArmazenagemId = @localArmazenagemId))) OR
                      (FabricanteAtivoId = @fabricanteAtivoId) AND (@tipoAtivoId IS NULL) AND (NOT EXISTS
                          (SELECT     LocalArmazenagemId, AtivoId, EstoqueAtual, EstoqueMinimo
                            FROM          Estoque AS Estoque_2
                            WHERE      (AtivoId = Ativo.AtivoId) AND (LocalArmazenagemId = @localArmazenagemId))) OR
                      (@fabricanteAtivoId IS NULL) AND (@tipoAtivoId IS NULL) AND (NOT EXISTS
                          (SELECT     LocalArmazenagemId, AtivoId, EstoqueAtual, EstoqueMinimo
                            FROM          Estoque AS Estoque_1
                            WHERE      (AtivoId = Ativo.AtivoId) AND (LocalArmazenagemId = @localArmazenagemId)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="localArmazenagemId" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@localArmazenagemId" Precision="0" Scale="0" Size="4" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="tipoAtivoId" ColumnName="TipoAtivoId" DataSourceName="ControleAtivo.dbo.Ativo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@tipoAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TipoAtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="fabricanteAtivoId" ColumnName="FabricanteAtivoId" DataSourceName="ControleAtivo.dbo.Ativo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@fabricanteAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FabricanteAtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AvisoTableAdapter" GeneratorDataComponentClassName="AvisoTableAdapter" Name="Aviso" UserDataComponentName="AvisoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.Aviso" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Aviso] WHERE (([AvisoId] = @Original_AvisoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AvisoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AvisoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Aviso] ([LocalArmazenagemId], [AtivoId], [MovimentacaoId], [AvisoTipo], [AvisoRealizado]) VALUES (@LocalArmazenagemId, @AtivoId, @MovimentacaoId, @AvisoTipo, @AvisoRealizado)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MovimentacaoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MovimentacaoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@AvisoTipo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="AvisoTipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@AvisoRealizado" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="AvisoRealizado" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AvisoId, LocalArmazenagemId, AtivoId, MovimentacaoId, AvisoTipo, AvisoRealizado FROM dbo.Aviso</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Aviso] SET [LocalArmazenagemId] = @LocalArmazenagemId, [AtivoId] = @AtivoId, [MovimentacaoId] = @MovimentacaoId, [AvisoTipo] = @AvisoTipo, [AvisoRealizado] = @AvisoRealizado WHERE (([AvisoId] = @Original_AvisoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MovimentacaoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MovimentacaoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@AvisoTipo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="AvisoTipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@AvisoRealizado" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="AvisoRealizado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AvisoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AvisoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AvisoId" DataSetColumn="AvisoId" />
              <Mapping SourceColumn="LocalArmazenagemId" DataSetColumn="LocalArmazenagemId" />
              <Mapping SourceColumn="AtivoId" DataSetColumn="AtivoId" />
              <Mapping SourceColumn="MovimentacaoId" DataSetColumn="MovimentacaoId" />
              <Mapping SourceColumn="AvisoTipo" DataSetColumn="AvisoTipo" />
              <Mapping SourceColumn="AvisoRealizado" DataSetColumn="AvisoRealizado" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CampoTableAdapter" GeneratorDataComponentClassName="CampoTableAdapter" Name="Campo" UserDataComponentName="CampoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.Campo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Campo] WHERE (([CampoId] = @Original_CampoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CampoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CampoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Campo] ([CampoNome], [CampoTipoValor]) VALUES (@CampoNome, @CampoTipoValor)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CampoNome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CampoNome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CampoTipoValor" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CampoTipoValor" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CampoId, CampoNome, CampoTipoValor FROM dbo.Campo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Campo] SET [CampoNome] = @CampoNome, [CampoTipoValor] = @CampoTipoValor WHERE (([CampoId] = @Original_CampoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CampoNome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CampoNome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CampoTipoValor" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CampoTipoValor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CampoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CampoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CampoId" DataSetColumn="CampoId" />
              <Mapping SourceColumn="CampoNome" DataSetColumn="CampoNome" />
              <Mapping SourceColumn="CampoTipoValor" DataSetColumn="CampoTipoValor" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.Campo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillNonAssociatedCampoByTipoAtivoId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataNonAssociatedCampoByTipoAtivoId" GeneratorSourceName="FillNonAssociatedCampoByTipoAtivoId" GetMethodModifier="Public" GetMethodName="GetDataNonAssociatedCampoByTipoAtivoId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataNonAssociatedCampoByTipoAtivoId" UserSourceName="FillNonAssociatedCampoByTipoAtivoId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     CampoId, CampoNome, CampoTipoValor
FROM         Campo
WHERE     (NOT EXISTS
                          (SELECT     CampoId, TipoAtivoId, CampoTipoAtivoObrigatorio
                            FROM          CampoTipoAtivo
                            WHERE      (TipoAtivoId = @tipoAtivoId) AND (CampoId = Campo.CampoId)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="tipoAtivoId" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@tipoAtivoId" Precision="0" Scale="0" Size="4" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CampoAtivoTableAdapter" GeneratorDataComponentClassName="CampoAtivoTableAdapter" Name="CampoAtivo" UserDataComponentName="CampoAtivoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.CampoAtivo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CampoAtivo] WHERE (([CampoId] = @Original_CampoId) AND ([AtivoId] = @Original_AtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CampoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CampoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CampoAtivo] ([CampoId], [AtivoId], [CampoAtivoValor]) VALUES (@CampoId, @AtivoId, @CampoAtivoValor)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CampoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CampoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CampoAtivoValor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CampoAtivoValor" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CampoId, AtivoId, CampoAtivoValor FROM dbo.CampoAtivo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CampoAtivo] SET [CampoId] = @CampoId, [AtivoId] = @AtivoId, [CampoAtivoValor] = @CampoAtivoValor WHERE (([CampoId] = @Original_CampoId) AND ([AtivoId] = @Original_AtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CampoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CampoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CampoAtivoValor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CampoAtivoValor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CampoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CampoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CampoId" DataSetColumn="CampoId" />
              <Mapping SourceColumn="AtivoId" DataSetColumn="AtivoId" />
              <Mapping SourceColumn="CampoAtivoValor" DataSetColumn="CampoAtivoValor" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByAtivoId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByAtivoId" GeneratorSourceName="FillByAtivoId" GetMethodModifier="Public" GetMethodName="GetDataByAtivoId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByAtivoId" UserSourceName="FillByAtivoId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Campo.CampoId, Ativo.AtivoId, COALESCE (CampoAtivo.CampoAtivoValor, '') AS CampoAtivoValor, 
                      CASE CampoTipoAtivo.CampoTipoAtivoObrigatorio WHEN 'S' THEN '* ' ELSE '' END + Campo.CampoNome AS CampoNome, 
                      CampoTipoAtivo.CampoTipoAtivoObrigatorio, Campo.CampoTipoValor, CASE WHEN CampoAtivo.AtivoId IS NULL 
                      THEN 'Insert' ELSE 'Update' END AS CommandName
FROM         Campo INNER JOIN
                      CampoTipoAtivo ON Campo.CampoId = CampoTipoAtivo.CampoId INNER JOIN
                      Ativo ON Ativo.TipoAtivoId = CampoTipoAtivo.TipoAtivoId LEFT OUTER JOIN
                      CampoAtivo ON Campo.CampoId = CampoAtivo.CampoId AND CampoAtivo.AtivoId = Ativo.AtivoId
WHERE     (Ativo.AtivoId = @ativoId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ativoId" ColumnName="AtivoId" DataSourceName="ControleAtivo.dbo.Ativo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ativoId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CampoTipoAtivoTableAdapter" GeneratorDataComponentClassName="CampoTipoAtivoTableAdapter" Name="CampoTipoAtivo" UserDataComponentName="CampoTipoAtivoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.CampoTipoAtivo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CampoTipoAtivo] WHERE (([CampoId] = @Original_CampoId) AND ([TipoAtivoId] = @Original_TipoAtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CampoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CampoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TipoAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoAtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CampoTipoAtivo] ([CampoId], [TipoAtivoId], [CampoTipoAtivoObrigatorio]) VALUES (@CampoId, @TipoAtivoId, @CampoTipoAtivoObrigatorio)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CampoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CampoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TipoAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoAtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CampoTipoAtivoObrigatorio" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CampoTipoAtivoObrigatorio" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CampoId, TipoAtivoId, CampoTipoAtivoObrigatorio FROM dbo.CampoTipoAtivo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CampoTipoAtivo] SET [CampoId] = @CampoId, [TipoAtivoId] = @TipoAtivoId, [CampoTipoAtivoObrigatorio] = @CampoTipoAtivoObrigatorio WHERE (([CampoId] = @Original_CampoId) AND ([TipoAtivoId] = @Original_TipoAtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CampoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CampoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TipoAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoAtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CampoTipoAtivoObrigatorio" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CampoTipoAtivoObrigatorio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CampoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CampoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TipoAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoAtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CampoId" DataSetColumn="CampoId" />
              <Mapping SourceColumn="TipoAtivoId" DataSetColumn="TipoAtivoId" />
              <Mapping SourceColumn="CampoTipoAtivoObrigatorio" DataSetColumn="CampoTipoAtivoObrigatorio" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByTipoAtivoId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTipoAtivoId" GeneratorSourceName="FillByTipoAtivoId" GetMethodModifier="Public" GetMethodName="GetDataByTipoAtivoId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTipoAtivoId" UserSourceName="FillByTipoAtivoId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     CampoTipoAtivo.CampoId, CampoTipoAtivo.TipoAtivoId, CampoTipoAtivo.CampoTipoAtivoObrigatorio, Campo.CampoNome
FROM         CampoTipoAtivo INNER JOIN
                      Campo ON CampoTipoAtivo.CampoId = Campo.CampoId
WHERE     (CampoTipoAtivo.TipoAtivoId = @tipoAtivoId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="tipoAtivoId" ColumnName="TipoAtivoId" DataSourceName="ControleAtivo.dbo.CampoTipoAtivo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@tipoAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TipoAtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ConfiguracaoTableAdapter" GeneratorDataComponentClassName="ConfiguracaoTableAdapter" Name="Configuracao" UserDataComponentName="ConfiguracaoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.Configuracao" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Configuracao] WHERE (([ConfiguracaoId] = @Original_ConfiguracaoId) AND ([ConfiguracaoTipoValor] = @Original_ConfiguracaoTipoValor) AND ([ConfiguracaoValor] = @Original_ConfiguracaoValor) AND ([ConfiguracaoChave] = @Original_ConfiguracaoChave))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ConfiguracaoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ConfiguracaoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ConfiguracaoTipoValor" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ConfiguracaoTipoValor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ConfiguracaoValor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ConfiguracaoValor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ConfiguracaoChave" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ConfiguracaoChave" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Configuracao] ([ConfiguracaoTipoValor], [ConfiguracaoValor], [ConfiguracaoChave]) VALUES (@ConfiguracaoTipoValor, @ConfiguracaoValor, @ConfiguracaoChave);
SELECT ConfiguracaoId, ConfiguracaoTipoValor, ConfiguracaoValor, ConfiguracaoChave FROM Configuracao WHERE (ConfiguracaoId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ConfiguracaoTipoValor" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ConfiguracaoTipoValor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ConfiguracaoValor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ConfiguracaoValor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ConfiguracaoChave" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ConfiguracaoChave" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ConfiguracaoId, ConfiguracaoTipoValor, ConfiguracaoValor, ConfiguracaoChave FROM Configuracao</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Configuracao] SET [ConfiguracaoTipoValor] = @ConfiguracaoTipoValor, [ConfiguracaoValor] = @ConfiguracaoValor, [ConfiguracaoChave] = @ConfiguracaoChave WHERE (([ConfiguracaoId] = @Original_ConfiguracaoId) AND ([ConfiguracaoTipoValor] = @Original_ConfiguracaoTipoValor) AND ([ConfiguracaoValor] = @Original_ConfiguracaoValor) AND ([ConfiguracaoChave] = @Original_ConfiguracaoChave));
SELECT ConfiguracaoId, ConfiguracaoTipoValor, ConfiguracaoValor, ConfiguracaoChave FROM Configuracao WHERE (ConfiguracaoId = @ConfiguracaoId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ConfiguracaoTipoValor" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ConfiguracaoTipoValor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ConfiguracaoValor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ConfiguracaoValor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ConfiguracaoChave" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ConfiguracaoChave" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ConfiguracaoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ConfiguracaoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ConfiguracaoTipoValor" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ConfiguracaoTipoValor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ConfiguracaoValor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ConfiguracaoValor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ConfiguracaoChave" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ConfiguracaoChave" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ConfiguracaoId" ColumnName="ConfiguracaoId" DataSourceName="ControleAtivo.dbo.Configuracao" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ConfiguracaoId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ConfiguracaoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ConfiguracaoId" DataSetColumn="ConfiguracaoId" />
              <Mapping SourceColumn="ConfiguracaoTipoValor" DataSetColumn="ConfiguracaoTipoValor" />
              <Mapping SourceColumn="ConfiguracaoValor" DataSetColumn="ConfiguracaoValor" />
              <Mapping SourceColumn="ConfiguracaoChave" DataSetColumn="ConfiguracaoChave" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.Configuracao" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByConfiguracaoChave" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByConfiguracaoChave" GeneratorSourceName="FillByConfiguracaoChave" GetMethodModifier="Public" GetMethodName="GetDataByConfiguracaoChave" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByConfiguracaoChave" UserSourceName="FillByConfiguracaoChave">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     ConfiguracaoId, ConfiguracaoTipoValor, ConfiguracaoValor, ConfiguracaoChave
FROM         Configuracao
WHERE     (ConfiguracaoChave = @configuracaoChave)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="configuracaoChave" ColumnName="ConfiguracaoChave" DataSourceName="ControleAtivo.dbo.Configuracao" DataTypeServer="varchar(15)" DbType="AnsiString" Direction="Input" ParameterName="@configuracaoChave" Precision="0" ProviderType="VarChar" Scale="0" Size="15" SourceColumn="ConfiguracaoChave" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EstoqueTableAdapter" GeneratorDataComponentClassName="EstoqueTableAdapter" Name="Estoque" UserDataComponentName="EstoqueTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.Estoque" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Estoque] WHERE (([LocalArmazenagemId] = @Original_LocalArmazenagemId) AND ([AtivoId] = @Original_AtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Estoque] ([LocalArmazenagemId], [AtivoId], [EstoqueAtual], [EstoqueMinimo]) VALUES (@LocalArmazenagemId, @AtivoId, @EstoqueAtual, @EstoqueMinimo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EstoqueAtual" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EstoqueAtual" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EstoqueMinimo" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EstoqueMinimo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT LocalArmazenagemId, AtivoId, EstoqueAtual, EstoqueMinimo FROM dbo.Estoque</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Estoque] SET [LocalArmazenagemId] = @LocalArmazenagemId, [AtivoId] = @AtivoId, [EstoqueAtual] = @EstoqueAtual, [EstoqueMinimo] = @EstoqueMinimo WHERE (([LocalArmazenagemId] = @Original_LocalArmazenagemId) AND ([AtivoId] = @Original_AtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EstoqueAtual" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EstoqueAtual" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EstoqueMinimo" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EstoqueMinimo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="LocalArmazenagemId" DataSetColumn="LocalArmazenagemId" />
              <Mapping SourceColumn="AtivoId" DataSetColumn="AtivoId" />
              <Mapping SourceColumn="EstoqueAtual" DataSetColumn="EstoqueAtual" />
              <Mapping SourceColumn="EstoqueMinimo" DataSetColumn="EstoqueMinimo" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByAtivoId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByAtivoId" GeneratorSourceName="FillByAtivoId" GetMethodModifier="Public" GetMethodName="GetDataByAtivoId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByAtivoId" UserSourceName="FillByAtivoId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Estoque.LocalArmazenagemId, Estoque.AtivoId, Estoque.EstoqueAtual, Estoque.EstoqueMinimo, LocalArmazenagem.LocalArmazenagemNome
FROM         Estoque INNER JOIN
                      LocalArmazenagem ON Estoque.LocalArmazenagemId = LocalArmazenagem.LocalArmazenagemId
WHERE     (Estoque.AtivoId = @ativoId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ativoId" ColumnName="AtivoId" DataSourceName="ControleAtivo.dbo.Estoque" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ativoId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByLocalArmazenagemId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLocalArmazenagemId" GeneratorSourceName="FillByLocalArmazenagemId" GetMethodModifier="Public" GetMethodName="GetDataByLocalArmazenagemId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLocalArmazenagemId" UserSourceName="FillByLocalArmazenagemId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Estoque.LocalArmazenagemId, Estoque.AtivoId, Estoque.EstoqueAtual, Estoque.EstoqueMinimo, Ativo.AtivoNome
FROM         Estoque INNER JOIN
                      Ativo ON Estoque.AtivoId = Ativo.AtivoId
WHERE     (Estoque.LocalArmazenagemId = @localArmazenagemId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="localArmazenagemId" ColumnName="LocalArmazenagemId" DataSourceName="ControleAtivo.dbo.Estoque" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@localArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FabricanteAtivoTableAdapter" GeneratorDataComponentClassName="FabricanteAtivoTableAdapter" Name="FabricanteAtivo" UserDataComponentName="FabricanteAtivoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.FabricanteAtivo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[FabricanteAtivo] WHERE (([FabricanteAtivoId] = @Original_FabricanteAtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FabricanteAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FabricanteAtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[FabricanteAtivo] ([FabricanteAtivoNome]) VALUES (@FabricanteAtivoNome)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FabricanteAtivoNome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FabricanteAtivoNome" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT FabricanteAtivoId, FabricanteAtivoNome FROM dbo.FabricanteAtivo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[FabricanteAtivo] SET [FabricanteAtivoNome] = @FabricanteAtivoNome WHERE (([FabricanteAtivoId] = @Original_FabricanteAtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FabricanteAtivoNome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FabricanteAtivoNome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FabricanteAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FabricanteAtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FabricanteAtivoId" DataSetColumn="FabricanteAtivoId" />
              <Mapping SourceColumn="FabricanteAtivoNome" DataSetColumn="FabricanteAtivoNome" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LocalArmazenagemTableAdapter" GeneratorDataComponentClassName="LocalArmazenagemTableAdapter" Name="LocalArmazenagem" UserDataComponentName="LocalArmazenagemTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.LocalArmazenagem" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[LocalArmazenagem] WHERE (([LocalArmazenagemId] = @Original_LocalArmazenagemId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[LocalArmazenagem] ([UsuarioId], [LocalArmazenagemNome], [LocalArmazenagemEndereco]) VALUES (@UsuarioId, @LocalArmazenagemNome, @LocalArmazenagemEndereco)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UsuarioId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UsuarioId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LocalArmazenagemNome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LocalArmazenagemNome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LocalArmazenagemEndereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LocalArmazenagemEndereco" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT LocalArmazenagemId, UsuarioId, LocalArmazenagemNome, LocalArmazenagemEndereco FROM dbo.LocalArmazenagem</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[LocalArmazenagem] SET [UsuarioId] = @UsuarioId, [LocalArmazenagemNome] = @LocalArmazenagemNome, [LocalArmazenagemEndereco] = @LocalArmazenagemEndereco WHERE (([LocalArmazenagemId] = @Original_LocalArmazenagemId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UsuarioId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UsuarioId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LocalArmazenagemNome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LocalArmazenagemNome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LocalArmazenagemEndereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LocalArmazenagemEndereco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="LocalArmazenagemId" DataSetColumn="LocalArmazenagemId" />
              <Mapping SourceColumn="UsuarioId" DataSetColumn="UsuarioId" />
              <Mapping SourceColumn="LocalArmazenagemNome" DataSetColumn="LocalArmazenagemNome" />
              <Mapping SourceColumn="LocalArmazenagemEndereco" DataSetColumn="LocalArmazenagemEndereco" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillWithUsuarioNome" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataWithUsuarioNome" GeneratorSourceName="FillWithUsuarioNome" GetMethodModifier="Public" GetMethodName="GetDataWithUsuarioNome" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataWithUsuarioNome" UserSourceName="FillWithUsuarioNome">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     LocalArmazenagem.LocalArmazenagemId, LocalArmazenagem.UsuarioId, LocalArmazenagem.LocalArmazenagemNome, 
                      LocalArmazenagem.LocalArmazenagemEndereco, Usuario.UsuarioNome
FROM         LocalArmazenagem LEFT OUTER JOIN
                      Usuario ON LocalArmazenagem.UsuarioId = Usuario.UsuarioId</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MovimentacaoTableAdapter" GeneratorDataComponentClassName="MovimentacaoTableAdapter" Name="Movimentacao" UserDataComponentName="MovimentacaoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.Movimentacao" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Movimentacao] WHERE (([MovimentacaoId] = @Original_MovimentacaoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MovimentacaoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MovimentacaoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Movimentacao] ([LocalArmazenagemId], [AtivoId], [MovimentacaoIdPai], [MovimentacaoData], [MovimentacaoLote], [MovimentacaoQuantidade], [MovimentacaoTipo], [MovimentacaoDataValidade], [EstoqueLocalizacaoRFID], [EstoqueLocalizacaoRFIDPai], [EstoqueLocalizacaoTamanhoCaixa]) VALUES (@LocalArmazenagemId, @AtivoId, @MovimentacaoIdPai, @MovimentacaoData, @MovimentacaoLote, @MovimentacaoQuantidade, @MovimentacaoTipo, @MovimentacaoDataValidade, @EstoqueLocalizacaoRFID, @EstoqueLocalizacaoRFIDPai, @EstoqueLocalizacaoTamanhoCaixa);
SELECT MovimentacaoId, LocalArmazenagemId, AtivoId, MovimentacaoIdPai, MovimentacaoData, MovimentacaoLote, MovimentacaoQuantidade, MovimentacaoTipo, MovimentacaoDataValidade, EstoqueLocalizacaoRFID, EstoqueLocalizacaoRFIDPai, EstoqueLocalizacaoTamanhoCaixa FROM Movimentacao WHERE (MovimentacaoId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MovimentacaoIdPai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MovimentacaoIdPai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MovimentacaoData" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MovimentacaoData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MovimentacaoLote" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MovimentacaoLote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MovimentacaoQuantidade" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="MovimentacaoQuantidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@MovimentacaoTipo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="MovimentacaoTipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MovimentacaoDataValidade" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MovimentacaoDataValidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@EstoqueLocalizacaoRFID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoRFID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@EstoqueLocalizacaoRFIDPai" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoRFIDPai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@EstoqueLocalizacaoTamanhoCaixa" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoTamanhoCaixa" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     MovimentacaoId, LocalArmazenagemId, AtivoId, MovimentacaoIdPai, MovimentacaoData, MovimentacaoLote, MovimentacaoQuantidade, 
                      MovimentacaoTipo, MovimentacaoDataValidade, EstoqueLocalizacaoRFID, EstoqueLocalizacaoRFIDPai, EstoqueLocalizacaoTamanhoCaixa
FROM         Movimentacao</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Movimentacao] SET [LocalArmazenagemId] = @LocalArmazenagemId, [AtivoId] = @AtivoId, [MovimentacaoIdPai] = @MovimentacaoIdPai, [MovimentacaoData] = @MovimentacaoData, [MovimentacaoLote] = @MovimentacaoLote, [MovimentacaoQuantidade] = @MovimentacaoQuantidade, [MovimentacaoTipo] = @MovimentacaoTipo, [MovimentacaoDataValidade] = @MovimentacaoDataValidade, [EstoqueLocalizacaoRFID] = @EstoqueLocalizacaoRFID, [EstoqueLocalizacaoRFIDPai] = @EstoqueLocalizacaoRFIDPai, [EstoqueLocalizacaoTamanhoCaixa] = @EstoqueLocalizacaoTamanhoCaixa WHERE (([MovimentacaoId] = @Original_MovimentacaoId));
SELECT MovimentacaoId, LocalArmazenagemId, AtivoId, MovimentacaoIdPai, MovimentacaoData, MovimentacaoLote, MovimentacaoQuantidade, MovimentacaoTipo, MovimentacaoDataValidade, EstoqueLocalizacaoRFID, EstoqueLocalizacaoRFIDPai, EstoqueLocalizacaoTamanhoCaixa FROM Movimentacao WHERE (MovimentacaoId = @MovimentacaoId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MovimentacaoIdPai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MovimentacaoIdPai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MovimentacaoData" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MovimentacaoData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MovimentacaoLote" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MovimentacaoLote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MovimentacaoQuantidade" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="MovimentacaoQuantidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@MovimentacaoTipo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="MovimentacaoTipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MovimentacaoDataValidade" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MovimentacaoDataValidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@EstoqueLocalizacaoRFID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoRFID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@EstoqueLocalizacaoRFIDPai" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoRFIDPai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@EstoqueLocalizacaoTamanhoCaixa" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoTamanhoCaixa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MovimentacaoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MovimentacaoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="MovimentacaoId" ColumnName="MovimentacaoId" DataSourceName="ControleAtivo.dbo.Movimentacao" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@MovimentacaoId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="MovimentacaoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MovimentacaoId" DataSetColumn="MovimentacaoId" />
              <Mapping SourceColumn="LocalArmazenagemId" DataSetColumn="LocalArmazenagemId" />
              <Mapping SourceColumn="AtivoId" DataSetColumn="AtivoId" />
              <Mapping SourceColumn="MovimentacaoIdPai" DataSetColumn="MovimentacaoIdPai" />
              <Mapping SourceColumn="MovimentacaoData" DataSetColumn="MovimentacaoData" />
              <Mapping SourceColumn="MovimentacaoLote" DataSetColumn="MovimentacaoLote" />
              <Mapping SourceColumn="MovimentacaoQuantidade" DataSetColumn="MovimentacaoQuantidade" />
              <Mapping SourceColumn="MovimentacaoTipo" DataSetColumn="MovimentacaoTipo" />
              <Mapping SourceColumn="MovimentacaoDataValidade" DataSetColumn="MovimentacaoDataValidade" />
              <Mapping SourceColumn="EstoqueLocalizacaoRFID" DataSetColumn="EstoqueLocalizacaoRFID" />
              <Mapping SourceColumn="EstoqueLocalizacaoRFIDPai" DataSetColumn="EstoqueLocalizacaoRFIDPai" />
              <Mapping SourceColumn="EstoqueLocalizacaoTamanhoCaixa" DataSetColumn="EstoqueLocalizacaoTamanhoCaixa" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PortalLeitorTableAdapter" GeneratorDataComponentClassName="PortalLeitorTableAdapter" Name="PortalLeitor" UserDataComponentName="PortalLeitorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.PortalLeitor" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [PortalLeitor] WHERE (([PortalLeitorId] = @Original_PortalLeitorId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PortalLeitorId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PortalLeitorId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [PortalLeitor] ([LocalArmazenagemId], [PortalLeitorIP], [PortalLeitorTCP], [PortalLeitorNumeroAntenas]) VALUES (@LocalArmazenagemId, @PortalLeitorIP, @PortalLeitorTCP, @PortalLeitorNumeroAntenas)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PortalLeitorIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PortalLeitorIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PortalLeitorTCP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PortalLeitorTCP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@PortalLeitorNumeroAntenas" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PortalLeitorNumeroAntenas" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     PortalLeitorId, LocalArmazenagemId, PortalLeitorIP, PortalLeitorTCP, PortalLeitorNumeroAntenas
FROM         PortalLeitor</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [PortalLeitor] SET [LocalArmazenagemId] = @LocalArmazenagemId, [PortalLeitorIP] = @PortalLeitorIP, [PortalLeitorTCP] = @PortalLeitorTCP, [PortalLeitorNumeroAntenas] = @PortalLeitorNumeroAntenas WHERE (([PortalLeitorId] = @Original_PortalLeitorId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PortalLeitorIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PortalLeitorIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PortalLeitorTCP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PortalLeitorTCP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@PortalLeitorNumeroAntenas" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PortalLeitorNumeroAntenas" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PortalLeitorId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PortalLeitorId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PortalLeitorId" DataSetColumn="PortalLeitorId" />
              <Mapping SourceColumn="LocalArmazenagemId" DataSetColumn="LocalArmazenagemId" />
              <Mapping SourceColumn="PortalLeitorIP" DataSetColumn="PortalLeitorIP" />
              <Mapping SourceColumn="PortalLeitorTCP" DataSetColumn="PortalLeitorTCP" />
              <Mapping SourceColumn="PortalLeitorNumeroAntenas" DataSetColumn="PortalLeitorNumeroAntenas" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.PortalLeitor" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLocalArmazenagemId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLocalArmazenagemId" GeneratorSourceName="FillByLocalArmazenagemId" GetMethodModifier="Public" GetMethodName="GetDataByLocalArmazenagemId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLocalArmazenagemId" UserSourceName="FillByLocalArmazenagemId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT LocalArmazenagemId, PortalLeitorIP, PortalLeitorId, PortalLeitorNumeroAntenas, PortalLeitorTCP FROM PortalLeitor WHERE (LocalArmazenagemId = @localArmazenagemId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="localArmazenagemId" ColumnName="LocalArmazenagemId" DataSourceName="ControleAtivo.dbo.PortalLeitor" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@localArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.PortalLeitor" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPortalLeitorId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPortalLeitorId" GeneratorSourceName="FillByPortalLeitorId" GetMethodModifier="Public" GetMethodName="GetDataByPortalLeitorId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPortalLeitorId" UserSourceName="FillByPortalLeitorId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     PortalLeitorId, LocalArmazenagemId, PortalLeitorIP, PortalLeitorTCP, PortalLeitorNumeroAntenas
FROM         PortalLeitor
WHERE     (PortalLeitorId = @portalLeitorId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="portalLeitorId" ColumnName="PortalLeitorId" DataSourceName="ControleAtivo.dbo.PortalLeitor" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@portalLeitorId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PortalLeitorId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillWithLocalArmazenagemNome" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataWithLocalArmazenagemNome" GeneratorSourceName="FillWithLocalArmazenagemNome" GetMethodModifier="Public" GetMethodName="GetDataWithLocalArmazenagemNome" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataWithLocalArmazenagemNome" UserSourceName="FillWithLocalArmazenagemNome">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     PortalLeitor.PortalLeitorId, PortalLeitor.LocalArmazenagemId, PortalLeitor.PortalLeitorIP, PortalLeitor.PortalLeitorTCP, 
                      PortalLeitor.PortalLeitorNumeroAntenas, LocalArmazenagem.LocalArmazenagemNome
FROM         PortalLeitor INNER JOIN
                      LocalArmazenagem ON PortalLeitor.LocalArmazenagemId = LocalArmazenagem.LocalArmazenagemId</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TipoAtivoTableAdapter" GeneratorDataComponentClassName="TipoAtivoTableAdapter" Name="TipoAtivo" UserDataComponentName="TipoAtivoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.TipoAtivo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TipoAtivo] WHERE (([TipoAtivoId] = @Original_TipoAtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TipoAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoAtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TipoAtivo] ([TipoAtivoNome]) VALUES (@TipoAtivoNome)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipoAtivoNome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoAtivoNome" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TipoAtivoId, TipoAtivoNome FROM dbo.TipoAtivo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TipoAtivo] SET [TipoAtivoNome] = @TipoAtivoNome WHERE (([TipoAtivoId] = @Original_TipoAtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipoAtivoNome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoAtivoNome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TipoAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoAtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TipoAtivoId" DataSetColumn="TipoAtivoId" />
              <Mapping SourceColumn="TipoAtivoNome" DataSetColumn="TipoAtivoNome" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SolicitacaoAtivoTableAdapter" GeneratorDataComponentClassName="SolicitacaoAtivoTableAdapter" Name="SolicitacaoAtivo" UserDataComponentName="SolicitacaoAtivoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.SolicitacaoAtivo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [SolicitacaoAtivo] WHERE (([SolicitacaoAtivoId] = @Original_SolicitacaoAtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SolicitacaoAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SolicitacaoAtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [SolicitacaoAtivo] ([AtivoId], [AvisoId], [SistemaCompraId], [SolicitacaoAtivoQuantidade], [SolicitacaoAtivoData], [SolicitacaoAtivoDataAtendida]) VALUES (@AtivoId, @AvisoId, @SistemaCompraId, @SolicitacaoAtivoQuantidade, @SolicitacaoAtivoData, @SolicitacaoAtivoDataAtendida)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AvisoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AvisoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SistemaCompraId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SistemaCompraId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SolicitacaoAtivoQuantidade" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="SolicitacaoAtivoQuantidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@SolicitacaoAtivoData" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SolicitacaoAtivoData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@SolicitacaoAtivoDataAtendida" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SolicitacaoAtivoDataAtendida" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     SolicitacaoAtivoId, AtivoId, AvisoId, SistemaCompraId, SolicitacaoAtivoQuantidade, SolicitacaoAtivoData, SolicitacaoAtivoDataAtendida
FROM         SolicitacaoAtivo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [SolicitacaoAtivo] SET [AtivoId] = @AtivoId, [AvisoId] = @AvisoId, [SistemaCompraId] = @SistemaCompraId, [SolicitacaoAtivoQuantidade] = @SolicitacaoAtivoQuantidade, [SolicitacaoAtivoData] = @SolicitacaoAtivoData, [SolicitacaoAtivoDataAtendida] = @SolicitacaoAtivoDataAtendida WHERE (([SolicitacaoAtivoId] = @Original_SolicitacaoAtivoId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AvisoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AvisoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SistemaCompraId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SistemaCompraId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SolicitacaoAtivoQuantidade" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="SolicitacaoAtivoQuantidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@SolicitacaoAtivoData" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SolicitacaoAtivoData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@SolicitacaoAtivoDataAtendida" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SolicitacaoAtivoDataAtendida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SolicitacaoAtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SolicitacaoAtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SolicitacaoAtivoId" DataSetColumn="SolicitacaoAtivoId" />
              <Mapping SourceColumn="AtivoId" DataSetColumn="AtivoId" />
              <Mapping SourceColumn="AvisoId" DataSetColumn="AvisoId" />
              <Mapping SourceColumn="SistemaCompraId" DataSetColumn="SistemaCompraId" />
              <Mapping SourceColumn="SolicitacaoAtivoQuantidade" DataSetColumn="SolicitacaoAtivoQuantidade" />
              <Mapping SourceColumn="SolicitacaoAtivoData" DataSetColumn="SolicitacaoAtivoData" />
              <Mapping SourceColumn="SolicitacaoAtivoDataAtendida" DataSetColumn="SolicitacaoAtivoDataAtendida" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EstoqueLocalizacaoTableAdapter" GeneratorDataComponentClassName="EstoqueLocalizacaoTableAdapter" Name="EstoqueLocalizacao" UserDataComponentName="EstoqueLocalizacaoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectName="ControleAtivo.dbo.EstoqueLocalizacao" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [EstoqueLocalizacao] WHERE (([EstoqueLocalizacaoRFID] = @Original_EstoqueLocalizacaoRFID) AND ((@IsNull_AtivoId = 1 AND [AtivoId] IS NULL) OR ([AtivoId] = @Original_AtivoId)) AND ([LocalArmazenagemId] = @Original_LocalArmazenagemId) AND ([EstoqueLocalizacaoRFIDPai] = @Original_EstoqueLocalizacaoRFIDPai) AND ([EstoqueLocalizacaoHierarquia] = @Original_EstoqueLocalizacaoHierarquia) AND ([EstoqueLocalizacaoTamanhoCaixa] = @Original_EstoqueLocalizacaoTamanhoCaixa) AND ((@IsNull_EstoqueLocalizacaoDataValidade = 1 AND [EstoqueLocalizacaoDataValidade] IS NULL) OR ([EstoqueLocalizacaoDataValidade] = @Original_EstoqueLocalizacaoDataValidade)) AND ([EstoqueLocalizacaoQuantidade] = @Original_EstoqueLocalizacaoQuantidade) AND ((@IsNull_EstoqueLocalizacaoLote = 1 AND [EstoqueLocalizacaoLote] IS NULL) OR ([EstoqueLocalizacaoLote] = @Original_EstoqueLocalizacaoLote)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoRFID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoRFID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoRFIDPai" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoRFIDPai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoHierarquia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoHierarquia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoTamanhoCaixa" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoTamanhoCaixa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EstoqueLocalizacaoDataValidade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoDataValidade" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoDataValidade" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoDataValidade" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoQuantidade" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EstoqueLocalizacaoQuantidade" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EstoqueLocalizacaoLote" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoLote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoLote" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoLote" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [EstoqueLocalizacao] ([EstoqueLocalizacaoRFID], [AtivoId], [LocalArmazenagemId], [EstoqueLocalizacaoRFIDPai], [EstoqueLocalizacaoHierarquia], [EstoqueLocalizacaoTamanhoCaixa], [EstoqueLocalizacaoDataValidade], [EstoqueLocalizacaoQuantidade], [EstoqueLocalizacaoLote]) VALUES (@EstoqueLocalizacaoRFID, @AtivoId, @LocalArmazenagemId, @EstoqueLocalizacaoRFIDPai, @EstoqueLocalizacaoHierarquia, @EstoqueLocalizacaoTamanhoCaixa, @EstoqueLocalizacaoDataValidade, @EstoqueLocalizacaoQuantidade, @EstoqueLocalizacaoLote);
SELECT EstoqueLocalizacaoRFID, AtivoId, LocalArmazenagemId, EstoqueLocalizacaoRFIDPai, EstoqueLocalizacaoHierarquia, EstoqueLocalizacaoTamanhoCaixa, EstoqueLocalizacaoDataValidade, EstoqueLocalizacaoQuantidade, EstoqueLocalizacaoLote FROM EstoqueLocalizacao WHERE (EstoqueLocalizacaoRFID = @EstoqueLocalizacaoRFID) AND (EstoqueLocalizacaoRFIDPai = @EstoqueLocalizacaoRFIDPai) AND (EstoqueLocalizacaoTamanhoCaixa = @EstoqueLocalizacaoTamanhoCaixa)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@EstoqueLocalizacaoRFID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoRFID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@EstoqueLocalizacaoRFIDPai" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoRFIDPai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EstoqueLocalizacaoHierarquia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoHierarquia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@EstoqueLocalizacaoTamanhoCaixa" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoTamanhoCaixa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EstoqueLocalizacaoDataValidade" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoDataValidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EstoqueLocalizacaoQuantidade" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EstoqueLocalizacaoQuantidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EstoqueLocalizacaoLote" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoLote" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT EstoqueLocalizacaoRFID, AtivoId, LocalArmazenagemId, EstoqueLocalizacaoRFIDPai, EstoqueLocalizacaoHierarquia, EstoqueLocalizacaoTamanhoCaixa, EstoqueLocalizacaoDataValidade, EstoqueLocalizacaoQuantidade, EstoqueLocalizacaoLote FROM EstoqueLocalizacao</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [EstoqueLocalizacao] SET [EstoqueLocalizacaoRFID] = @EstoqueLocalizacaoRFID, [AtivoId] = @AtivoId, [LocalArmazenagemId] = @LocalArmazenagemId, [EstoqueLocalizacaoRFIDPai] = @EstoqueLocalizacaoRFIDPai, [EstoqueLocalizacaoHierarquia] = @EstoqueLocalizacaoHierarquia, [EstoqueLocalizacaoTamanhoCaixa] = @EstoqueLocalizacaoTamanhoCaixa, [EstoqueLocalizacaoDataValidade] = @EstoqueLocalizacaoDataValidade, [EstoqueLocalizacaoQuantidade] = @EstoqueLocalizacaoQuantidade, [EstoqueLocalizacaoLote] = @EstoqueLocalizacaoLote WHERE (([EstoqueLocalizacaoRFID] = @Original_EstoqueLocalizacaoRFID) AND ((@IsNull_AtivoId = 1 AND [AtivoId] IS NULL) OR ([AtivoId] = @Original_AtivoId)) AND ([LocalArmazenagemId] = @Original_LocalArmazenagemId) AND ([EstoqueLocalizacaoRFIDPai] = @Original_EstoqueLocalizacaoRFIDPai) AND ([EstoqueLocalizacaoHierarquia] = @Original_EstoqueLocalizacaoHierarquia) AND ([EstoqueLocalizacaoTamanhoCaixa] = @Original_EstoqueLocalizacaoTamanhoCaixa) AND ((@IsNull_EstoqueLocalizacaoDataValidade = 1 AND [EstoqueLocalizacaoDataValidade] IS NULL) OR ([EstoqueLocalizacaoDataValidade] = @Original_EstoqueLocalizacaoDataValidade)) AND ([EstoqueLocalizacaoQuantidade] = @Original_EstoqueLocalizacaoQuantidade) AND ((@IsNull_EstoqueLocalizacaoLote = 1 AND [EstoqueLocalizacaoLote] IS NULL) OR ([EstoqueLocalizacaoLote] = @Original_EstoqueLocalizacaoLote)));
SELECT EstoqueLocalizacaoRFID, AtivoId, LocalArmazenagemId, EstoqueLocalizacaoRFIDPai, EstoqueLocalizacaoHierarquia, EstoqueLocalizacaoTamanhoCaixa, EstoqueLocalizacaoDataValidade, EstoqueLocalizacaoQuantidade, EstoqueLocalizacaoLote FROM EstoqueLocalizacao WHERE (EstoqueLocalizacaoRFID = @EstoqueLocalizacaoRFID) AND (EstoqueLocalizacaoRFIDPai = @EstoqueLocalizacaoRFIDPai) AND (EstoqueLocalizacaoTamanhoCaixa = @EstoqueLocalizacaoTamanhoCaixa)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@EstoqueLocalizacaoRFID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoRFID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@EstoqueLocalizacaoRFIDPai" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoRFIDPai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EstoqueLocalizacaoHierarquia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoHierarquia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@EstoqueLocalizacaoTamanhoCaixa" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoTamanhoCaixa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EstoqueLocalizacaoDataValidade" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoDataValidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EstoqueLocalizacaoQuantidade" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EstoqueLocalizacaoQuantidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EstoqueLocalizacaoLote" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoLote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoRFID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoRFID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AtivoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AtivoId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LocalArmazenagemId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocalArmazenagemId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoRFIDPai" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoRFIDPai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoHierarquia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoHierarquia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoTamanhoCaixa" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoTamanhoCaixa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EstoqueLocalizacaoDataValidade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoDataValidade" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoDataValidade" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoDataValidade" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoQuantidade" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="EstoqueLocalizacaoQuantidade" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EstoqueLocalizacaoLote" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoLote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EstoqueLocalizacaoLote" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EstoqueLocalizacaoLote" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EstoqueLocalizacaoRFID" DataSetColumn="EstoqueLocalizacaoRFID" />
              <Mapping SourceColumn="AtivoId" DataSetColumn="AtivoId" />
              <Mapping SourceColumn="LocalArmazenagemId" DataSetColumn="LocalArmazenagemId" />
              <Mapping SourceColumn="EstoqueLocalizacaoRFIDPai" DataSetColumn="EstoqueLocalizacaoRFIDPai" />
              <Mapping SourceColumn="EstoqueLocalizacaoHierarquia" DataSetColumn="EstoqueLocalizacaoHierarquia" />
              <Mapping SourceColumn="EstoqueLocalizacaoTamanhoCaixa" DataSetColumn="EstoqueLocalizacaoTamanhoCaixa" />
              <Mapping SourceColumn="EstoqueLocalizacaoDataValidade" DataSetColumn="EstoqueLocalizacaoDataValidade" />
              <Mapping SourceColumn="EstoqueLocalizacaoQuantidade" DataSetColumn="EstoqueLocalizacaoQuantidade" />
              <Mapping SourceColumn="EstoqueLocalizacaoLote" DataSetColumn="EstoqueLocalizacaoLote" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ControleAtivoConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="ConsultarEstoque" Modifier="Public" Name="ConsultarEstoque" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="ConsultarEstoque">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     dbo.ConsultaEstoque(@ativoId, @localArmazenagemId, @estoqueLocalizacaoRFID, @movimentacaoDataInicial, @movimentacaoDataFinal) AS Expr1</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ativoId" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@ativoId" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="localArmazenagemId" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@localArmazenagemId" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="estoqueLocalizacaoRFID" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName="@estoqueLocalizacaoRFID" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="movimentacaoDataInicial" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="DateTime" Direction="Input" ParameterName="@movimentacaoDataInicial" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="movimentacaoDataFinal" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="DateTime" Direction="Input" ParameterName="@movimentacaoDataFinal" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ControleAtivoDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ControleAtivoDataSet" msprop:Generator_DataSetName="ControleAtivoDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Usuario" msprop:Generator_UserTableName="Usuario" msprop:Generator_RowDeletedName="UsuarioRowDeleted" msprop:Generator_RowChangedName="UsuarioRowChanged" msprop:Generator_RowClassName="UsuarioRow" msprop:Generator_RowChangingName="UsuarioRowChanging" msprop:Generator_RowEvArgName="UsuarioRowChangeEvent" msprop:Generator_RowEvHandlerName="UsuarioRowChangeEventHandler" msprop:Generator_TableClassName="UsuarioDataTable" msprop:Generator_TableVarName="tableUsuario" msprop:Generator_RowDeletingName="UsuarioRowDeleting" msprop:Generator_TablePropName="Usuario">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UsuarioId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msdata:Caption="Identificador" msprop:Generator_UserColumnName="UsuarioId" msprop:Generator_ColumnVarNameInTable="columnUsuarioId" msprop:Generator_ColumnPropNameInRow="UsuarioId" msprop:Generator_ColumnPropNameInTable="UsuarioIdColumn" type="xs:int" />
              <xs:element name="UsuarioNome" msdata:Caption="Nome" msprop:Generator_UserColumnName="UsuarioNome" msprop:Generator_ColumnVarNameInTable="columnUsuarioNome" msprop:Generator_ColumnPropNameInRow="UsuarioNome" msprop:Generator_ColumnPropNameInTable="UsuarioNomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UsuarioMatricula" msdata:Caption="Matrícula" msprop:Generator_UserColumnName="UsuarioMatricula" msprop:Generator_ColumnVarNameInTable="columnUsuarioMatricula" msprop:Generator_ColumnPropNameInRow="UsuarioMatricula" msprop:Generator_ColumnPropNameInTable="UsuarioMatriculaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UsuarioSenha" msdata:Caption="Senha" msprop:Generator_UserColumnName="UsuarioSenha" msprop:Generator_ColumnVarNameInTable="columnUsuarioSenha" msprop:Generator_ColumnPropNameInRow="UsuarioSenha" msprop:Generator_ColumnPropNameInTable="UsuarioSenhaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UsuarioTipo" msdata:Caption="Tipo" msprop:Generator_UserColumnName="UsuarioTipo" msprop:Generator_ColumnVarNameInTable="columnUsuarioTipo" msprop:Generator_ColumnPropNameInRow="UsuarioTipo" msprop:Generator_ColumnPropNameInTable="UsuarioTipoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UsuarioEmail" msprop:Generator_UserColumnName="UsuarioEmail" msprop:Generator_ColumnVarNameInTable="columnUsuarioEmail" msprop:Generator_ColumnPropNameInRow="UsuarioEmail" msprop:Generator_ColumnPropNameInTable="UsuarioEmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Ativo" msprop:Generator_UserTableName="Ativo" msprop:Generator_RowDeletedName="AtivoRowDeleted" msprop:Generator_RowChangedName="AtivoRowChanged" msprop:Generator_RowClassName="AtivoRow" msprop:Generator_RowChangingName="AtivoRowChanging" msprop:Generator_RowEvArgName="AtivoRowChangeEvent" msprop:Generator_RowEvHandlerName="AtivoRowChangeEventHandler" msprop:Generator_TableClassName="AtivoDataTable" msprop:Generator_TableVarName="tableAtivo" msprop:Generator_RowDeletingName="AtivoRowDeleting" msprop:Generator_TablePropName="Ativo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AtivoId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msdata:Caption="Identificador" msprop:Generator_UserColumnName="AtivoId" msprop:Generator_ColumnPropNameInRow="AtivoId" msprop:Generator_ColumnVarNameInTable="columnAtivoId" msprop:Generator_ColumnPropNameInTable="AtivoIdColumn" type="xs:int" />
              <xs:element name="TipoAtivoId" msdata:Caption="Tipo de Ativo" msprop:Generator_UserColumnName="TipoAtivoId" msprop:Generator_ColumnPropNameInRow="TipoAtivoId" msprop:Generator_ColumnVarNameInTable="columnTipoAtivoId" msprop:Generator_ColumnPropNameInTable="TipoAtivoIdColumn" type="xs:int" />
              <xs:element name="FabricanteAtivoId" msdata:Caption="Fabricante de Ativo" msprop:Generator_UserColumnName="FabricanteAtivoId" msprop:Generator_ColumnPropNameInRow="FabricanteAtivoId" msprop:Generator_ColumnVarNameInTable="columnFabricanteAtivoId" msprop:Generator_ColumnPropNameInTable="FabricanteAtivoIdColumn" type="xs:int" />
              <xs:element name="AtivoNome" msdata:Caption="Nome" msprop:Generator_UserColumnName="AtivoNome" msprop:Generator_ColumnPropNameInRow="AtivoNome" msprop:Generator_ColumnVarNameInTable="columnAtivoNome" msprop:Generator_ColumnPropNameInTable="AtivoNomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AtivoRFID" msdata:Caption="RFID" msprop:Generator_UserColumnName="AtivoRFID" msprop:Generator_ColumnPropNameInRow="AtivoRFID" msprop:Generator_ColumnVarNameInTable="columnAtivoRFID" msprop:Generator_ColumnPropNameInTable="AtivoRFIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1080" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FabricanteAtivoNome" msprop:Generator_UserColumnName="FabricanteAtivoNome" msprop:Generator_ColumnVarNameInTable="columnFabricanteAtivoNome" msprop:Generator_ColumnPropNameInRow="FabricanteAtivoNome" msprop:Generator_ColumnPropNameInTable="FabricanteAtivoNomeColumn" type="xs:string" minOccurs="0" />
              <xs:element name="TipoAtivoNome" msprop:Generator_UserColumnName="TipoAtivoNome" msprop:Generator_ColumnVarNameInTable="columnTipoAtivoNome" msprop:Generator_ColumnPropNameInRow="TipoAtivoNome" msprop:Generator_ColumnPropNameInTable="TipoAtivoNomeColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Aviso" msprop:Generator_UserTableName="Aviso" msprop:Generator_RowDeletedName="AvisoRowDeleted" msprop:Generator_RowChangedName="AvisoRowChanged" msprop:Generator_RowClassName="AvisoRow" msprop:Generator_RowChangingName="AvisoRowChanging" msprop:Generator_RowEvArgName="AvisoRowChangeEvent" msprop:Generator_RowEvHandlerName="AvisoRowChangeEventHandler" msprop:Generator_TableClassName="AvisoDataTable" msprop:Generator_TableVarName="tableAviso" msprop:Generator_RowDeletingName="AvisoRowDeleting" msprop:Generator_TablePropName="Aviso">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AvisoId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="AvisoId" msprop:Generator_ColumnPropNameInRow="AvisoId" msprop:Generator_ColumnVarNameInTable="columnAvisoId" msprop:Generator_ColumnPropNameInTable="AvisoIdColumn" type="xs:int" />
              <xs:element name="LocalArmazenagemId" msprop:Generator_UserColumnName="LocalArmazenagemId" msprop:Generator_ColumnPropNameInRow="LocalArmazenagemId" msprop:Generator_ColumnVarNameInTable="columnLocalArmazenagemId" msprop:Generator_ColumnPropNameInTable="LocalArmazenagemIdColumn" type="xs:int" />
              <xs:element name="AtivoId" msprop:Generator_UserColumnName="AtivoId" msprop:Generator_ColumnPropNameInRow="AtivoId" msprop:Generator_ColumnVarNameInTable="columnAtivoId" msprop:Generator_ColumnPropNameInTable="AtivoIdColumn" type="xs:int" />
              <xs:element name="MovimentacaoId" msprop:Generator_UserColumnName="MovimentacaoId" msprop:Generator_ColumnPropNameInRow="MovimentacaoId" msprop:Generator_ColumnVarNameInTable="columnMovimentacaoId" msprop:Generator_ColumnPropNameInTable="MovimentacaoIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="AvisoTipo" msprop:Generator_UserColumnName="AvisoTipo" msprop:Generator_ColumnPropNameInRow="AvisoTipo" msprop:Generator_ColumnVarNameInTable="columnAvisoTipo" msprop:Generator_ColumnPropNameInTable="AvisoTipoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AvisoRealizado" msprop:Generator_UserColumnName="AvisoRealizado" msprop:Generator_ColumnPropNameInRow="AvisoRealizado" msprop:Generator_ColumnVarNameInTable="columnAvisoRealizado" msprop:Generator_ColumnPropNameInTable="AvisoRealizadoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Campo" msprop:Generator_UserTableName="Campo" msprop:Generator_RowDeletedName="CampoRowDeleted" msprop:Generator_RowChangedName="CampoRowChanged" msprop:Generator_RowClassName="CampoRow" msprop:Generator_RowChangingName="CampoRowChanging" msprop:Generator_RowEvArgName="CampoRowChangeEvent" msprop:Generator_RowEvHandlerName="CampoRowChangeEventHandler" msprop:Generator_TableClassName="CampoDataTable" msprop:Generator_TableVarName="tableCampo" msprop:Generator_RowDeletingName="CampoRowDeleting" msprop:Generator_TablePropName="Campo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CampoId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="CampoId" msprop:Generator_ColumnPropNameInRow="CampoId" msprop:Generator_ColumnVarNameInTable="columnCampoId" msprop:Generator_ColumnPropNameInTable="CampoIdColumn" type="xs:int" />
              <xs:element name="CampoNome" msprop:Generator_UserColumnName="CampoNome" msprop:Generator_ColumnPropNameInRow="CampoNome" msprop:Generator_ColumnVarNameInTable="columnCampoNome" msprop:Generator_ColumnPropNameInTable="CampoNomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CampoTipoValor" msprop:Generator_UserColumnName="CampoTipoValor" msprop:Generator_ColumnPropNameInRow="CampoTipoValor" msprop:Generator_ColumnVarNameInTable="columnCampoTipoValor" msprop:Generator_ColumnPropNameInTable="CampoTipoValorColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CampoAtivo" msprop:Generator_UserTableName="CampoAtivo" msprop:Generator_RowDeletedName="CampoAtivoRowDeleted" msprop:Generator_RowChangedName="CampoAtivoRowChanged" msprop:Generator_RowClassName="CampoAtivoRow" msprop:Generator_RowChangingName="CampoAtivoRowChanging" msprop:Generator_RowEvArgName="CampoAtivoRowChangeEvent" msprop:Generator_RowEvHandlerName="CampoAtivoRowChangeEventHandler" msprop:Generator_TableClassName="CampoAtivoDataTable" msprop:Generator_TableVarName="tableCampoAtivo" msprop:Generator_RowDeletingName="CampoAtivoRowDeleting" msprop:Generator_TablePropName="CampoAtivo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CampoId" msprop:Generator_UserColumnName="CampoId" msprop:Generator_ColumnPropNameInRow="CampoId" msprop:Generator_ColumnVarNameInTable="columnCampoId" msprop:Generator_ColumnPropNameInTable="CampoIdColumn" type="xs:int" />
              <xs:element name="AtivoId" msprop:Generator_UserColumnName="AtivoId" msprop:Generator_ColumnPropNameInRow="AtivoId" msprop:Generator_ColumnVarNameInTable="columnAtivoId" msprop:Generator_ColumnPropNameInTable="AtivoIdColumn" type="xs:int" />
              <xs:element name="CampoAtivoValor" msprop:Generator_UserColumnName="CampoAtivoValor" msprop:Generator_ColumnPropNameInRow="CampoAtivoValor" msprop:Generator_ColumnVarNameInTable="columnCampoAtivoValor" msprop:Generator_ColumnPropNameInTable="CampoAtivoValorColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1024" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CampoTipoAtivo" msprop:Generator_UserTableName="CampoTipoAtivo" msprop:Generator_RowDeletedName="CampoTipoAtivoRowDeleted" msprop:Generator_RowChangedName="CampoTipoAtivoRowChanged" msprop:Generator_RowClassName="CampoTipoAtivoRow" msprop:Generator_RowChangingName="CampoTipoAtivoRowChanging" msprop:Generator_RowEvArgName="CampoTipoAtivoRowChangeEvent" msprop:Generator_RowEvHandlerName="CampoTipoAtivoRowChangeEventHandler" msprop:Generator_TableClassName="CampoTipoAtivoDataTable" msprop:Generator_TableVarName="tableCampoTipoAtivo" msprop:Generator_RowDeletingName="CampoTipoAtivoRowDeleting" msprop:Generator_TablePropName="CampoTipoAtivo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CampoId" msprop:Generator_UserColumnName="CampoId" msprop:Generator_ColumnPropNameInRow="CampoId" msprop:Generator_ColumnVarNameInTable="columnCampoId" msprop:Generator_ColumnPropNameInTable="CampoIdColumn" type="xs:int" />
              <xs:element name="TipoAtivoId" msprop:Generator_UserColumnName="TipoAtivoId" msprop:Generator_ColumnPropNameInRow="TipoAtivoId" msprop:Generator_ColumnVarNameInTable="columnTipoAtivoId" msprop:Generator_ColumnPropNameInTable="TipoAtivoIdColumn" type="xs:int" />
              <xs:element name="CampoTipoAtivoObrigatorio" msprop:Generator_UserColumnName="CampoTipoAtivoObrigatorio" msprop:Generator_ColumnPropNameInRow="CampoTipoAtivoObrigatorio" msprop:Generator_ColumnVarNameInTable="columnCampoTipoAtivoObrigatorio" msprop:Generator_ColumnPropNameInTable="CampoTipoAtivoObrigatorioColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Configuracao" msprop:Generator_UserTableName="Configuracao" msprop:Generator_RowDeletedName="ConfiguracaoRowDeleted" msprop:Generator_RowChangedName="ConfiguracaoRowChanged" msprop:Generator_RowClassName="ConfiguracaoRow" msprop:Generator_RowChangingName="ConfiguracaoRowChanging" msprop:Generator_RowEvArgName="ConfiguracaoRowChangeEvent" msprop:Generator_RowEvHandlerName="ConfiguracaoRowChangeEventHandler" msprop:Generator_TableClassName="ConfiguracaoDataTable" msprop:Generator_TableVarName="tableConfiguracao" msprop:Generator_RowDeletingName="ConfiguracaoRowDeleting" msprop:Generator_TablePropName="Configuracao">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ConfiguracaoId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ConfiguracaoId" msprop:Generator_ColumnPropNameInRow="ConfiguracaoId" msprop:Generator_ColumnVarNameInTable="columnConfiguracaoId" msprop:Generator_ColumnPropNameInTable="ConfiguracaoIdColumn" type="xs:int" />
              <xs:element name="ConfiguracaoTipoValor" msprop:Generator_UserColumnName="ConfiguracaoTipoValor" msprop:Generator_ColumnPropNameInRow="ConfiguracaoTipoValor" msprop:Generator_ColumnVarNameInTable="columnConfiguracaoTipoValor" msprop:Generator_ColumnPropNameInTable="ConfiguracaoTipoValorColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ConfiguracaoValor" msprop:Generator_UserColumnName="ConfiguracaoValor" msprop:Generator_ColumnPropNameInRow="ConfiguracaoValor" msprop:Generator_ColumnVarNameInTable="columnConfiguracaoValor" msprop:Generator_ColumnPropNameInTable="ConfiguracaoValorColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1024" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ConfiguracaoChave" msprop:Generator_UserColumnName="ConfiguracaoChave" msprop:Generator_ColumnPropNameInRow="ConfiguracaoChave" msprop:Generator_ColumnVarNameInTable="columnConfiguracaoChave" msprop:Generator_ColumnPropNameInTable="ConfiguracaoChaveColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Estoque" msprop:Generator_UserTableName="Estoque" msprop:Generator_RowDeletedName="EstoqueRowDeleted" msprop:Generator_RowChangedName="EstoqueRowChanged" msprop:Generator_RowClassName="EstoqueRow" msprop:Generator_RowChangingName="EstoqueRowChanging" msprop:Generator_RowEvArgName="EstoqueRowChangeEvent" msprop:Generator_RowEvHandlerName="EstoqueRowChangeEventHandler" msprop:Generator_TableClassName="EstoqueDataTable" msprop:Generator_TableVarName="tableEstoque" msprop:Generator_RowDeletingName="EstoqueRowDeleting" msprop:Generator_TablePropName="Estoque">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="LocalArmazenagemId" msprop:Generator_UserColumnName="LocalArmazenagemId" msprop:Generator_ColumnPropNameInRow="LocalArmazenagemId" msprop:Generator_ColumnVarNameInTable="columnLocalArmazenagemId" msprop:Generator_ColumnPropNameInTable="LocalArmazenagemIdColumn" type="xs:int" />
              <xs:element name="AtivoId" msprop:Generator_UserColumnName="AtivoId" msprop:Generator_ColumnPropNameInRow="AtivoId" msprop:Generator_ColumnVarNameInTable="columnAtivoId" msprop:Generator_ColumnPropNameInTable="AtivoIdColumn" type="xs:int" />
              <xs:element name="EstoqueAtual" msprop:Generator_UserColumnName="EstoqueAtual" msprop:Generator_ColumnPropNameInRow="EstoqueAtual" msprop:Generator_ColumnVarNameInTable="columnEstoqueAtual" msprop:Generator_ColumnPropNameInTable="EstoqueAtualColumn" type="xs:decimal" />
              <xs:element name="EstoqueMinimo" msprop:Generator_UserColumnName="EstoqueMinimo" msprop:Generator_ColumnPropNameInRow="EstoqueMinimo" msprop:Generator_ColumnVarNameInTable="columnEstoqueMinimo" msprop:Generator_ColumnPropNameInTable="EstoqueMinimoColumn" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FabricanteAtivo" msprop:Generator_UserTableName="FabricanteAtivo" msprop:Generator_RowDeletedName="FabricanteAtivoRowDeleted" msprop:Generator_RowChangedName="FabricanteAtivoRowChanged" msprop:Generator_RowClassName="FabricanteAtivoRow" msprop:Generator_RowChangingName="FabricanteAtivoRowChanging" msprop:Generator_RowEvArgName="FabricanteAtivoRowChangeEvent" msprop:Generator_RowEvHandlerName="FabricanteAtivoRowChangeEventHandler" msprop:Generator_TableClassName="FabricanteAtivoDataTable" msprop:Generator_TableVarName="tableFabricanteAtivo" msprop:Generator_RowDeletingName="FabricanteAtivoRowDeleting" msprop:Generator_TablePropName="FabricanteAtivo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FabricanteAtivoId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="FabricanteAtivoId" msprop:Generator_ColumnPropNameInRow="FabricanteAtivoId" msprop:Generator_ColumnVarNameInTable="columnFabricanteAtivoId" msprop:Generator_ColumnPropNameInTable="FabricanteAtivoIdColumn" type="xs:int" />
              <xs:element name="FabricanteAtivoNome" msprop:Generator_UserColumnName="FabricanteAtivoNome" msprop:Generator_ColumnPropNameInRow="FabricanteAtivoNome" msprop:Generator_ColumnVarNameInTable="columnFabricanteAtivoNome" msprop:Generator_ColumnPropNameInTable="FabricanteAtivoNomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="LocalArmazenagem" msprop:Generator_UserTableName="LocalArmazenagem" msprop:Generator_RowDeletedName="LocalArmazenagemRowDeleted" msprop:Generator_RowChangedName="LocalArmazenagemRowChanged" msprop:Generator_RowClassName="LocalArmazenagemRow" msprop:Generator_RowChangingName="LocalArmazenagemRowChanging" msprop:Generator_RowEvArgName="LocalArmazenagemRowChangeEvent" msprop:Generator_RowEvHandlerName="LocalArmazenagemRowChangeEventHandler" msprop:Generator_TableClassName="LocalArmazenagemDataTable" msprop:Generator_TableVarName="tableLocalArmazenagem" msprop:Generator_RowDeletingName="LocalArmazenagemRowDeleting" msprop:Generator_TablePropName="LocalArmazenagem">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="LocalArmazenagemId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="LocalArmazenagemId" msprop:Generator_ColumnPropNameInRow="LocalArmazenagemId" msprop:Generator_ColumnVarNameInTable="columnLocalArmazenagemId" msprop:Generator_ColumnPropNameInTable="LocalArmazenagemIdColumn" type="xs:int" />
              <xs:element name="UsuarioId" msprop:Generator_UserColumnName="UsuarioId" msprop:Generator_ColumnPropNameInRow="UsuarioId" msprop:Generator_ColumnVarNameInTable="columnUsuarioId" msprop:Generator_ColumnPropNameInTable="UsuarioIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="LocalArmazenagemNome" msprop:Generator_UserColumnName="LocalArmazenagemNome" msprop:Generator_ColumnPropNameInRow="LocalArmazenagemNome" msprop:Generator_ColumnVarNameInTable="columnLocalArmazenagemNome" msprop:Generator_ColumnPropNameInTable="LocalArmazenagemNomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LocalArmazenagemEndereco" msprop:Generator_UserColumnName="LocalArmazenagemEndereco" msprop:Generator_ColumnPropNameInRow="LocalArmazenagemEndereco" msprop:Generator_ColumnVarNameInTable="columnLocalArmazenagemEndereco" msprop:Generator_ColumnPropNameInTable="LocalArmazenagemEnderecoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Movimentacao" msprop:Generator_UserTableName="Movimentacao" msprop:Generator_RowDeletedName="MovimentacaoRowDeleted" msprop:Generator_RowChangedName="MovimentacaoRowChanged" msprop:Generator_RowClassName="MovimentacaoRow" msprop:Generator_RowChangingName="MovimentacaoRowChanging" msprop:Generator_RowEvArgName="MovimentacaoRowChangeEvent" msprop:Generator_RowEvHandlerName="MovimentacaoRowChangeEventHandler" msprop:Generator_TableClassName="MovimentacaoDataTable" msprop:Generator_TableVarName="tableMovimentacao" msprop:Generator_RowDeletingName="MovimentacaoRowDeleting" msprop:Generator_TablePropName="Movimentacao">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MovimentacaoId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="MovimentacaoId" msprop:Generator_ColumnPropNameInRow="MovimentacaoId" msprop:Generator_ColumnVarNameInTable="columnMovimentacaoId" msprop:Generator_ColumnPropNameInTable="MovimentacaoIdColumn" type="xs:int" />
              <xs:element name="LocalArmazenagemId" msprop:Generator_UserColumnName="LocalArmazenagemId" msprop:Generator_ColumnPropNameInRow="LocalArmazenagemId" msprop:Generator_ColumnVarNameInTable="columnLocalArmazenagemId" msprop:Generator_ColumnPropNameInTable="LocalArmazenagemIdColumn" type="xs:int" />
              <xs:element name="AtivoId" msprop:Generator_UserColumnName="AtivoId" msprop:Generator_ColumnPropNameInRow="AtivoId" msprop:Generator_ColumnVarNameInTable="columnAtivoId" msprop:Generator_ColumnPropNameInTable="AtivoIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MovimentacaoIdPai" msprop:Generator_UserColumnName="MovimentacaoIdPai" msprop:Generator_ColumnPropNameInRow="MovimentacaoIdPai" msprop:Generator_ColumnVarNameInTable="columnMovimentacaoIdPai" msprop:Generator_ColumnPropNameInTable="MovimentacaoIdPaiColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MovimentacaoData" msprop:Generator_UserColumnName="MovimentacaoData" msprop:Generator_ColumnPropNameInRow="MovimentacaoData" msprop:Generator_ColumnVarNameInTable="columnMovimentacaoData" msprop:Generator_ColumnPropNameInTable="MovimentacaoDataColumn" type="xs:dateTime" />
              <xs:element name="MovimentacaoLote" msprop:Generator_UserColumnName="MovimentacaoLote" msprop:Generator_ColumnPropNameInRow="MovimentacaoLote" msprop:Generator_ColumnVarNameInTable="columnMovimentacaoLote" msprop:Generator_ColumnPropNameInTable="MovimentacaoLoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MovimentacaoQuantidade" msprop:Generator_UserColumnName="MovimentacaoQuantidade" msprop:Generator_ColumnPropNameInRow="MovimentacaoQuantidade" msprop:Generator_ColumnVarNameInTable="columnMovimentacaoQuantidade" msprop:Generator_ColumnPropNameInTable="MovimentacaoQuantidadeColumn" type="xs:decimal" />
              <xs:element name="MovimentacaoTipo" msprop:Generator_UserColumnName="MovimentacaoTipo" msprop:Generator_ColumnPropNameInRow="MovimentacaoTipo" msprop:Generator_ColumnVarNameInTable="columnMovimentacaoTipo" msprop:Generator_ColumnPropNameInTable="MovimentacaoTipoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MovimentacaoDataValidade" msprop:Generator_UserColumnName="MovimentacaoDataValidade" msprop:Generator_ColumnPropNameInRow="MovimentacaoDataValidade" msprop:Generator_ColumnVarNameInTable="columnMovimentacaoDataValidade" msprop:Generator_ColumnPropNameInTable="MovimentacaoDataValidadeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EstoqueLocalizacaoRFID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="EstoqueLocalizacaoRFID" msprop:Generator_ColumnPropNameInRow="EstoqueLocalizacaoRFID" msprop:Generator_ColumnVarNameInTable="columnEstoqueLocalizacaoRFID" msprop:Generator_ColumnPropNameInTable="EstoqueLocalizacaoRFIDColumn" type="xs:string" />
              <xs:element name="EstoqueLocalizacaoRFIDPai" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="EstoqueLocalizacaoRFIDPai" msprop:Generator_ColumnPropNameInRow="EstoqueLocalizacaoRFIDPai" msprop:Generator_ColumnVarNameInTable="columnEstoqueLocalizacaoRFIDPai" msprop:Generator_ColumnPropNameInTable="EstoqueLocalizacaoRFIDPaiColumn" type="xs:string" />
              <xs:element name="AtivoNotFound" msprop:Generator_UserColumnName="AtivoNotFound" msprop:nullValue="False" msprop:Generator_ColumnVarNameInTable="columnAtivoNotFound" msprop:Generator_ColumnPropNameInTable="AtivoNotFoundColumn" msprop:Generator_ColumnPropNameInRow="AtivoNotFound" type="xs:boolean" default="false" />
              <xs:element name="EstoqueLocalizacaoTamanhoCaixa" msprop:Generator_UserColumnName="EstoqueLocalizacaoTamanhoCaixa" msprop:nullValue="0" msprop:Generator_ColumnVarNameInTable="columnEstoqueLocalizacaoTamanhoCaixa" msprop:Generator_ColumnPropNameInTable="EstoqueLocalizacaoTamanhoCaixaColumn" msprop:Generator_ColumnPropNameInRow="EstoqueLocalizacaoTamanhoCaixa" type="xs:unsignedByte" default="0" />
              <xs:element name="AtivoNome" msprop:Generator_UserColumnName="AtivoNome" msprop:nullValue="_empty" msprop:Generator_ColumnVarNameInTable="columnAtivoNome" msprop:Generator_ColumnPropNameInTable="AtivoNomeColumn" msprop:Generator_ColumnPropNameInRow="AtivoNome" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PortalLeitor" msprop:Generator_UserTableName="PortalLeitor" msprop:Generator_RowDeletedName="PortalLeitorRowDeleted" msprop:Generator_RowChangedName="PortalLeitorRowChanged" msprop:Generator_RowClassName="PortalLeitorRow" msprop:Generator_RowChangingName="PortalLeitorRowChanging" msprop:Generator_RowEvArgName="PortalLeitorRowChangeEvent" msprop:Generator_RowEvHandlerName="PortalLeitorRowChangeEventHandler" msprop:Generator_TableClassName="PortalLeitorDataTable" msprop:Generator_TableVarName="tablePortalLeitor" msprop:Generator_RowDeletingName="PortalLeitorRowDeleting" msprop:Generator_TablePropName="PortalLeitor">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PortalLeitorId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="PortalLeitorId" msprop:Generator_ColumnPropNameInRow="PortalLeitorId" msprop:Generator_ColumnVarNameInTable="columnPortalLeitorId" msprop:Generator_ColumnPropNameInTable="PortalLeitorIdColumn" type="xs:int" />
              <xs:element name="LocalArmazenagemId" msprop:Generator_UserColumnName="LocalArmazenagemId" msprop:Generator_ColumnPropNameInRow="LocalArmazenagemId" msprop:Generator_ColumnVarNameInTable="columnLocalArmazenagemId" msprop:Generator_ColumnPropNameInTable="LocalArmazenagemIdColumn" type="xs:int" />
              <xs:element name="PortalLeitorIP" msprop:Generator_UserColumnName="PortalLeitorIP" msprop:Generator_ColumnPropNameInRow="PortalLeitorIP" msprop:Generator_ColumnVarNameInTable="columnPortalLeitorIP" msprop:Generator_ColumnPropNameInTable="PortalLeitorIPColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1024" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PortalLeitorTCP" msprop:Generator_UserColumnName="PortalLeitorTCP" msprop:Generator_ColumnPropNameInRow="PortalLeitorTCP" msprop:Generator_ColumnVarNameInTable="columnPortalLeitorTCP" msprop:Generator_ColumnPropNameInTable="PortalLeitorTCPColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PortalLeitorNumeroAntenas" msprop:Generator_UserColumnName="PortalLeitorNumeroAntenas" msprop:Generator_ColumnVarNameInTable="columnPortalLeitorNumeroAntenas" msprop:Generator_ColumnPropNameInRow="PortalLeitorNumeroAntenas" msprop:Generator_ColumnPropNameInTable="PortalLeitorNumeroAntenasColumn" type="xs:unsignedByte" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TipoAtivo" msprop:Generator_UserTableName="TipoAtivo" msprop:Generator_RowDeletedName="TipoAtivoRowDeleted" msprop:Generator_RowChangedName="TipoAtivoRowChanged" msprop:Generator_RowClassName="TipoAtivoRow" msprop:Generator_RowChangingName="TipoAtivoRowChanging" msprop:Generator_RowEvArgName="TipoAtivoRowChangeEvent" msprop:Generator_RowEvHandlerName="TipoAtivoRowChangeEventHandler" msprop:Generator_TableClassName="TipoAtivoDataTable" msprop:Generator_TableVarName="tableTipoAtivo" msprop:Generator_RowDeletingName="TipoAtivoRowDeleting" msprop:Generator_TablePropName="TipoAtivo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TipoAtivoId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="TipoAtivoId" msprop:Generator_ColumnPropNameInRow="TipoAtivoId" msprop:Generator_ColumnVarNameInTable="columnTipoAtivoId" msprop:Generator_ColumnPropNameInTable="TipoAtivoIdColumn" type="xs:int" />
              <xs:element name="TipoAtivoNome" msprop:Generator_UserColumnName="TipoAtivoNome" msprop:Generator_ColumnPropNameInRow="TipoAtivoNome" msprop:Generator_ColumnVarNameInTable="columnTipoAtivoNome" msprop:Generator_ColumnPropNameInTable="TipoAtivoNomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SolicitacaoAtivo" msprop:Generator_UserTableName="SolicitacaoAtivo" msprop:Generator_RowDeletedName="SolicitacaoAtivoRowDeleted" msprop:Generator_RowChangedName="SolicitacaoAtivoRowChanged" msprop:Generator_RowClassName="SolicitacaoAtivoRow" msprop:Generator_RowChangingName="SolicitacaoAtivoRowChanging" msprop:Generator_RowEvArgName="SolicitacaoAtivoRowChangeEvent" msprop:Generator_RowEvHandlerName="SolicitacaoAtivoRowChangeEventHandler" msprop:Generator_TableClassName="SolicitacaoAtivoDataTable" msprop:Generator_TableVarName="tableSolicitacaoAtivo" msprop:Generator_RowDeletingName="SolicitacaoAtivoRowDeleting" msprop:Generator_TablePropName="SolicitacaoAtivo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SolicitacaoAtivoId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="SolicitacaoAtivoId" msprop:Generator_ColumnPropNameInRow="SolicitacaoAtivoId" msprop:Generator_ColumnVarNameInTable="columnSolicitacaoAtivoId" msprop:Generator_ColumnPropNameInTable="SolicitacaoAtivoIdColumn" type="xs:int" />
              <xs:element name="AtivoId" msprop:Generator_UserColumnName="AtivoId" msprop:Generator_ColumnPropNameInRow="AtivoId" msprop:Generator_ColumnVarNameInTable="columnAtivoId" msprop:Generator_ColumnPropNameInTable="AtivoIdColumn" type="xs:int" />
              <xs:element name="AvisoId" msprop:Generator_UserColumnName="AvisoId" msprop:Generator_ColumnPropNameInRow="AvisoId" msprop:Generator_ColumnVarNameInTable="columnAvisoId" msprop:Generator_ColumnPropNameInTable="AvisoIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SistemaCompraId" msprop:Generator_UserColumnName="SistemaCompraId" msprop:Generator_ColumnPropNameInRow="SistemaCompraId" msprop:Generator_ColumnVarNameInTable="columnSistemaCompraId" msprop:Generator_ColumnPropNameInTable="SistemaCompraIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SolicitacaoAtivoQuantidade" msprop:Generator_UserColumnName="SolicitacaoAtivoQuantidade" msprop:Generator_ColumnPropNameInRow="SolicitacaoAtivoQuantidade" msprop:Generator_ColumnVarNameInTable="columnSolicitacaoAtivoQuantidade" msprop:Generator_ColumnPropNameInTable="SolicitacaoAtivoQuantidadeColumn" type="xs:decimal" />
              <xs:element name="SolicitacaoAtivoData" msprop:Generator_UserColumnName="SolicitacaoAtivoData" msprop:Generator_ColumnPropNameInRow="SolicitacaoAtivoData" msprop:Generator_ColumnVarNameInTable="columnSolicitacaoAtivoData" msprop:Generator_ColumnPropNameInTable="SolicitacaoAtivoDataColumn" type="xs:dateTime" />
              <xs:element name="SolicitacaoAtivoDataAtendida" msprop:Generator_UserColumnName="SolicitacaoAtivoDataAtendida" msprop:Generator_ColumnPropNameInRow="SolicitacaoAtivoDataAtendida" msprop:Generator_ColumnVarNameInTable="columnSolicitacaoAtivoDataAtendida" msprop:Generator_ColumnPropNameInTable="SolicitacaoAtivoDataAtendidaColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EstoqueLocalizacao" msprop:Generator_UserTableName="EstoqueLocalizacao" msprop:Generator_RowDeletedName="EstoqueLocalizacaoRowDeleted" msprop:Generator_RowChangedName="EstoqueLocalizacaoRowChanged" msprop:Generator_RowClassName="EstoqueLocalizacaoRow" msprop:Generator_RowChangingName="EstoqueLocalizacaoRowChanging" msprop:Generator_RowEvArgName="EstoqueLocalizacaoRowChangeEvent" msprop:Generator_RowEvHandlerName="EstoqueLocalizacaoRowChangeEventHandler" msprop:Generator_TableClassName="EstoqueLocalizacaoDataTable" msprop:Generator_TableVarName="tableEstoqueLocalizacao" msprop:Generator_RowDeletingName="EstoqueLocalizacaoRowDeleting" msprop:Generator_TablePropName="EstoqueLocalizacao">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EstoqueLocalizacaoRFID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="EstoqueLocalizacaoRFID" msprop:Generator_ColumnPropNameInRow="EstoqueLocalizacaoRFID" msprop:Generator_ColumnVarNameInTable="columnEstoqueLocalizacaoRFID" msprop:Generator_ColumnPropNameInTable="EstoqueLocalizacaoRFIDColumn" type="xs:string" />
              <xs:element name="AtivoId" msprop:Generator_UserColumnName="AtivoId" msprop:Generator_ColumnPropNameInRow="AtivoId" msprop:Generator_ColumnVarNameInTable="columnAtivoId" msprop:Generator_ColumnPropNameInTable="AtivoIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="LocalArmazenagemId" msprop:Generator_UserColumnName="LocalArmazenagemId" msprop:Generator_ColumnPropNameInRow="LocalArmazenagemId" msprop:Generator_ColumnVarNameInTable="columnLocalArmazenagemId" msprop:Generator_ColumnPropNameInTable="LocalArmazenagemIdColumn" type="xs:int" />
              <xs:element name="EstoqueLocalizacaoRFIDPai" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="EstoqueLocalizacaoRFIDPai" msprop:Generator_ColumnPropNameInRow="EstoqueLocalizacaoRFIDPai" msprop:Generator_ColumnVarNameInTable="columnEstoqueLocalizacaoRFIDPai" msprop:Generator_ColumnPropNameInTable="EstoqueLocalizacaoRFIDPaiColumn" type="xs:string" />
              <xs:element name="EstoqueLocalizacaoHierarquia" msprop:Generator_UserColumnName="EstoqueLocalizacaoHierarquia" msprop:Generator_ColumnPropNameInRow="EstoqueLocalizacaoHierarquia" msprop:Generator_ColumnVarNameInTable="columnEstoqueLocalizacaoHierarquia" msprop:Generator_ColumnPropNameInTable="EstoqueLocalizacaoHierarquiaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="900" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EstoqueLocalizacaoTamanhoCaixa" msprop:Generator_UserColumnName="EstoqueLocalizacaoTamanhoCaixa" msprop:Generator_ColumnPropNameInRow="EstoqueLocalizacaoTamanhoCaixa" msprop:Generator_ColumnVarNameInTable="columnEstoqueLocalizacaoTamanhoCaixa" msprop:Generator_ColumnPropNameInTable="EstoqueLocalizacaoTamanhoCaixaColumn" type="xs:unsignedByte" />
              <xs:element name="EstoqueLocalizacaoDataValidade" msprop:Generator_UserColumnName="EstoqueLocalizacaoDataValidade" msprop:Generator_ColumnPropNameInRow="EstoqueLocalizacaoDataValidade" msprop:Generator_ColumnVarNameInTable="columnEstoqueLocalizacaoDataValidade" msprop:Generator_ColumnPropNameInTable="EstoqueLocalizacaoDataValidadeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EstoqueLocalizacaoQuantidade" msprop:Generator_UserColumnName="EstoqueLocalizacaoQuantidade" msprop:Generator_ColumnPropNameInRow="EstoqueLocalizacaoQuantidade" msprop:Generator_ColumnVarNameInTable="columnEstoqueLocalizacaoQuantidade" msprop:Generator_ColumnPropNameInTable="EstoqueLocalizacaoQuantidadeColumn" type="xs:decimal" />
              <xs:element name="EstoqueLocalizacaoLote" msprop:Generator_UserColumnName="EstoqueLocalizacaoLote" msprop:Generator_ColumnVarNameInTable="columnEstoqueLocalizacaoLote" msprop:Generator_ColumnPropNameInRow="EstoqueLocalizacaoLote" msprop:Generator_ColumnPropNameInTable="EstoqueLocalizacaoLoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Usuario" />
      <xs:field xpath="mstns:UsuarioId" />
    </xs:unique>
    <xs:unique name="Ativo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Ativo" />
      <xs:field xpath="mstns:AtivoId" />
    </xs:unique>
    <xs:unique name="Aviso_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Aviso" />
      <xs:field xpath="mstns:AvisoId" />
    </xs:unique>
    <xs:unique name="Campo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Campo" />
      <xs:field xpath="mstns:CampoId" />
    </xs:unique>
    <xs:unique name="CampoAtivo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CampoAtivo" />
      <xs:field xpath="mstns:CampoId" />
      <xs:field xpath="mstns:AtivoId" />
    </xs:unique>
    <xs:unique name="CampoTipoAtivo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CampoTipoAtivo" />
      <xs:field xpath="mstns:CampoId" />
      <xs:field xpath="mstns:TipoAtivoId" />
    </xs:unique>
    <xs:unique name="Configuracao_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Configuracao" />
      <xs:field xpath="mstns:ConfiguracaoId" />
    </xs:unique>
    <xs:unique name="Estoque_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Estoque" />
      <xs:field xpath="mstns:LocalArmazenagemId" />
      <xs:field xpath="mstns:AtivoId" />
    </xs:unique>
    <xs:unique name="FabricanteAtivo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FabricanteAtivo" />
      <xs:field xpath="mstns:FabricanteAtivoId" />
    </xs:unique>
    <xs:unique name="LocalArmazenagem_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:LocalArmazenagem" />
      <xs:field xpath="mstns:LocalArmazenagemId" />
    </xs:unique>
    <xs:unique name="Movimentacao_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Movimentacao" />
      <xs:field xpath="mstns:MovimentacaoId" />
    </xs:unique>
    <xs:unique name="PortalLeitor_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PortalLeitor" />
      <xs:field xpath="mstns:PortalLeitorId" />
    </xs:unique>
    <xs:unique name="TipoAtivo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TipoAtivo" />
      <xs:field xpath="mstns:TipoAtivoId" />
    </xs:unique>
    <xs:unique name="SolicitacaoAtivo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SolicitacaoAtivo" />
      <xs:field xpath="mstns:SolicitacaoAtivoId" />
    </xs:unique>
    <xs:unique name="EstoqueLocalizacao_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EstoqueLocalizacao" />
      <xs:field xpath="mstns:EstoqueLocalizacaoRFIDPai" />
      <xs:field xpath="mstns:EstoqueLocalizacaoRFID" />
      <xs:field xpath="mstns:EstoqueLocalizacaoTamanhoCaixa" />
    </xs:unique>
    <xs:keyref name="FK_EstoqueLocalizacao_Movimentacao" refer="EstoqueLocalizacao_Constraint1" msprop:rel_Generator_UserRelationName="FK_Movimentacao_EstoqueLocalizacao1" msprop:rel_Generator_RelationVarName="relationFK_Movimentacao_EstoqueLocalizacao1" msprop:rel_Generator_UserChildTable="Movimentacao" msprop:rel_Generator_UserParentTable="EstoqueLocalizacao" msprop:rel_Generator_ParentPropName="EstoqueLocalizacaoRowParentByFK_Movimentacao_EstoqueLocalizacao1" msprop:rel_Generator_ChildPropName="GetMovimentacaoRowsByFK_Movimentacao_EstoqueLocalizacao1" msdata:RelationName="FK_Movimentacao_EstoqueLocalizacao1">
      <xs:selector xpath=".//mstns:Movimentacao" />
      <xs:field xpath="mstns:EstoqueLocalizacaoRFID" />
      <xs:field xpath="mstns:EstoqueLocalizacaoRFIDPai" />
      <xs:field xpath="mstns:EstoqueLocalizacaoTamanhoCaixa" />
    </xs:keyref>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Ativo_FabricanteAtivo" msdata:parent="FabricanteAtivo" msdata:child="Ativo" msdata:parentkey="FabricanteAtivoId" msdata:childkey="FabricanteAtivoId" msprop:Generator_UserRelationName="FK_Ativo_FabricanteAtivo" msprop:Generator_RelationVarName="relationFK_Ativo_FabricanteAtivo" msprop:Generator_UserChildTable="Ativo" msprop:Generator_UserParentTable="FabricanteAtivo" msprop:Generator_ParentPropName="FabricanteAtivoRow" msprop:Generator_ChildPropName="GetAtivoRows" />
      <msdata:Relationship name="FK_Ativo_TipoAtivo" msdata:parent="TipoAtivo" msdata:child="Ativo" msdata:parentkey="TipoAtivoId" msdata:childkey="TipoAtivoId" msprop:Generator_UserRelationName="FK_Ativo_TipoAtivo" msprop:Generator_RelationVarName="relationFK_Ativo_TipoAtivo" msprop:Generator_UserChildTable="Ativo" msprop:Generator_UserParentTable="TipoAtivo" msprop:Generator_ParentPropName="TipoAtivoRow" msprop:Generator_ChildPropName="GetAtivoRows" />
      <msdata:Relationship name="FK_Aviso_Ativo" msdata:parent="Ativo" msdata:child="Aviso" msdata:parentkey="AtivoId" msdata:childkey="AtivoId" msprop:Generator_UserRelationName="FK_Aviso_Ativo" msprop:Generator_RelationVarName="relationFK_Aviso_Ativo" msprop:Generator_UserChildTable="Aviso" msprop:Generator_UserParentTable="Ativo" msprop:Generator_ParentPropName="AtivoRow" msprop:Generator_ChildPropName="GetAvisoRows" />
      <msdata:Relationship name="FK_Aviso_LocalArmazena" msdata:parent="LocalArmazenagem" msdata:child="Aviso" msdata:parentkey="LocalArmazenagemId" msdata:childkey="LocalArmazenagemId" msprop:Generator_UserRelationName="FK_Aviso_LocalArmazena" msprop:Generator_RelationVarName="relationFK_Aviso_LocalArmazena" msprop:Generator_UserChildTable="Aviso" msprop:Generator_UserParentTable="LocalArmazenagem" msprop:Generator_ParentPropName="LocalArmazenagemRow" msprop:Generator_ChildPropName="GetAvisoRows" />
      <msdata:Relationship name="FK_Aviso_Movimentacao" msdata:parent="Movimentacao" msdata:child="Aviso" msdata:parentkey="MovimentacaoId" msdata:childkey="MovimentacaoId" msprop:Generator_UserRelationName="FK_Aviso_Movimentacao" msprop:Generator_RelationVarName="relationFK_Aviso_Movimentacao" msprop:Generator_UserChildTable="Aviso" msprop:Generator_UserParentTable="Movimentacao" msprop:Generator_ParentPropName="MovimentacaoRow" msprop:Generator_ChildPropName="GetAvisoRows" />
      <msdata:Relationship name="FK_CampoAtivo_Ativo" msdata:parent="Ativo" msdata:child="CampoAtivo" msdata:parentkey="AtivoId" msdata:childkey="AtivoId" msprop:Generator_UserRelationName="FK_CampoAtivo_Ativo" msprop:Generator_RelationVarName="relationFK_CampoAtivo_Ativo" msprop:Generator_UserChildTable="CampoAtivo" msprop:Generator_UserParentTable="Ativo" msprop:Generator_ParentPropName="AtivoRow" msprop:Generator_ChildPropName="GetCampoAtivoRows" />
      <msdata:Relationship name="FK_CampoAtivo_Campo" msdata:parent="Campo" msdata:child="CampoAtivo" msdata:parentkey="CampoId" msdata:childkey="CampoId" msprop:Generator_UserRelationName="FK_CampoAtivo_Campo" msprop:Generator_RelationVarName="relationFK_CampoAtivo_Campo" msprop:Generator_UserChildTable="CampoAtivo" msprop:Generator_UserParentTable="Campo" msprop:Generator_ParentPropName="CampoRow" msprop:Generator_ChildPropName="GetCampoAtivoRows" />
      <msdata:Relationship name="FK_CampoTipoAtivo_Campo" msdata:parent="Campo" msdata:child="CampoTipoAtivo" msdata:parentkey="CampoId" msdata:childkey="CampoId" msprop:Generator_UserRelationName="FK_CampoTipoAtivo_Campo" msprop:Generator_RelationVarName="relationFK_CampoTipoAtivo_Campo" msprop:Generator_UserChildTable="CampoTipoAtivo" msprop:Generator_UserParentTable="Campo" msprop:Generator_ParentPropName="CampoRow" msprop:Generator_ChildPropName="GetCampoTipoAtivoRows" />
      <msdata:Relationship name="FK_CampoTipoAtivo_TipoAtivo" msdata:parent="TipoAtivo" msdata:child="CampoTipoAtivo" msdata:parentkey="TipoAtivoId" msdata:childkey="TipoAtivoId" msprop:Generator_UserRelationName="FK_CampoTipoAtivo_TipoAtivo" msprop:Generator_RelationVarName="relationFK_CampoTipoAtivo_TipoAtivo" msprop:Generator_UserChildTable="CampoTipoAtivo" msprop:Generator_UserParentTable="TipoAtivo" msprop:Generator_ParentPropName="TipoAtivoRow" msprop:Generator_ChildPropName="GetCampoTipoAtivoRows" />
      <msdata:Relationship name="FK_Estoque_Ativo" msdata:parent="Ativo" msdata:child="Estoque" msdata:parentkey="AtivoId" msdata:childkey="AtivoId" msprop:Generator_UserRelationName="FK_Estoque_Ativo" msprop:Generator_RelationVarName="relationFK_Estoque_Ativo" msprop:Generator_UserChildTable="Estoque" msprop:Generator_UserParentTable="Ativo" msprop:Generator_ParentPropName="AtivoRow" msprop:Generator_ChildPropName="GetEstoqueRows" />
      <msdata:Relationship name="FK_Estoque_LocalArmazenagem" msdata:parent="LocalArmazenagem" msdata:child="Estoque" msdata:parentkey="LocalArmazenagemId" msdata:childkey="LocalArmazenagemId" msprop:Generator_UserRelationName="FK_Estoque_LocalArmazenagem" msprop:Generator_RelationVarName="relationFK_Estoque_LocalArmazenagem" msprop:Generator_UserChildTable="Estoque" msprop:Generator_UserParentTable="LocalArmazenagem" msprop:Generator_ParentPropName="LocalArmazenagemRow" msprop:Generator_ChildPropName="GetEstoqueRows" />
      <msdata:Relationship name="FK_LocalArmazenagem_Usuario" msdata:parent="Usuario" msdata:child="LocalArmazenagem" msdata:parentkey="UsuarioId" msdata:childkey="UsuarioId" msprop:Generator_UserRelationName="FK_LocalArmazenagem_Usuario" msprop:Generator_RelationVarName="relationFK_LocalArmazenagem_Usuario" msprop:Generator_UserChildTable="LocalArmazenagem" msprop:Generator_UserParentTable="Usuario" msprop:Generator_ParentPropName="UsuarioRow" msprop:Generator_ChildPropName="GetLocalArmazenagemRows" />
      <msdata:Relationship name="FK_Movimentacao_Ativo" msdata:parent="Ativo" msdata:child="Movimentacao" msdata:parentkey="AtivoId" msdata:childkey="AtivoId" msprop:Generator_UserRelationName="FK_Movimentacao_Ativo" msprop:Generator_RelationVarName="relationFK_Movimentacao_Ativo" msprop:Generator_UserChildTable="Movimentacao" msprop:Generator_UserParentTable="Ativo" msprop:Generator_ParentPropName="AtivoRow" msprop:Generator_ChildPropName="GetMovimentacaoRows" />
      <msdata:Relationship name="FK_Movimentacao_LocalArmazena" msdata:parent="LocalArmazenagem" msdata:child="Movimentacao" msdata:parentkey="LocalArmazenagemId" msdata:childkey="LocalArmazenagemId" msprop:Generator_UserRelationName="FK_Movimentacao_LocalArmazena" msprop:Generator_RelationVarName="relationFK_Movimentacao_LocalArmazena" msprop:Generator_UserChildTable="Movimentacao" msprop:Generator_UserParentTable="LocalArmazenagem" msprop:Generator_ParentPropName="LocalArmazenagemRow" msprop:Generator_ChildPropName="GetMovimentacaoRows" />
      <msdata:Relationship name="FK_Movimentacao_Movimenta_Pai" msdata:parent="Movimentacao" msdata:child="Movimentacao" msdata:parentkey="MovimentacaoId" msdata:childkey="MovimentacaoIdPai" msprop:Generator_UserRelationName="FK_Movimentacao_Movimenta_Pai" msprop:Generator_RelationVarName="relationFK_Movimentacao_Movimenta_Pai" msprop:Generator_UserChildTable="Movimentacao" msprop:Generator_UserParentTable="Movimentacao" msprop:Generator_ParentPropName="MovimentacaoRowParent" msprop:Generator_ChildPropName="GetMovimentacaoRows" />
      <msdata:Relationship name="FK_PortalLeitor_LocalArmazena" msdata:parent="LocalArmazenagem" msdata:child="PortalLeitor" msdata:parentkey="LocalArmazenagemId" msdata:childkey="LocalArmazenagemId" msprop:Generator_UserRelationName="FK_PortalLeitor_LocalArmazena" msprop:Generator_RelationVarName="relationFK_PortalLeitor_LocalArmazena" msprop:Generator_UserChildTable="PortalLeitor" msprop:Generator_UserParentTable="LocalArmazenagem" msprop:Generator_ParentPropName="LocalArmazenagemRow" msprop:Generator_ChildPropName="GetPortalLeitorRows" />
      <msdata:Relationship name="FK_SolicitacaoAtivo_Ativo" msdata:parent="Ativo" msdata:child="SolicitacaoAtivo" msdata:parentkey="AtivoId" msdata:childkey="AtivoId" msprop:Generator_UserRelationName="FK_SolicitacaoAtivo_Ativo" msprop:Generator_RelationVarName="relationFK_SolicitacaoAtivo_Ativo" msprop:Generator_UserChildTable="SolicitacaoAtivo" msprop:Generator_UserParentTable="Ativo" msprop:Generator_ParentPropName="AtivoRow" msprop:Generator_ChildPropName="GetSolicitacaoAtivoRows" />
      <msdata:Relationship name="FK_SolicitacaoAtivo_Aviso" msdata:parent="Aviso" msdata:child="SolicitacaoAtivo" msdata:parentkey="AvisoId" msdata:childkey="AvisoId" msprop:Generator_UserRelationName="FK_SolicitacaoAtivo_Aviso" msprop:Generator_RelationVarName="relationFK_SolicitacaoAtivo_Aviso" msprop:Generator_UserChildTable="SolicitacaoAtivo" msprop:Generator_UserParentTable="Aviso" msprop:Generator_ParentPropName="AvisoRow" msprop:Generator_ChildPropName="GetSolicitacaoAtivoRows" />
      <msdata:Relationship name="FK_EstoqueLocalizacao_Ativo" msdata:parent="Ativo" msdata:child="EstoqueLocalizacao" msdata:parentkey="AtivoId" msdata:childkey="AtivoId" msprop:Generator_UserRelationName="FK_EstoqueLocalizacao_Ativo" msprop:Generator_RelationVarName="relationFK_EstoqueLocalizacao_Ativo" msprop:Generator_UserChildTable="EstoqueLocalizacao" msprop:Generator_UserParentTable="Ativo" msprop:Generator_ParentPropName="AtivoRow" msprop:Generator_ChildPropName="GetEstoqueLocalizacaoRows" />
      <msdata:Relationship name="FK_EstoqueLocalizacao_LocalArmazenagem" msdata:parent="LocalArmazenagem" msdata:child="EstoqueLocalizacao" msdata:parentkey="LocalArmazenagemId" msdata:childkey="LocalArmazenagemId" msprop:Generator_UserRelationName="FK_EstoqueLocalizacao_LocalArmazenagem" msprop:Generator_RelationVarName="relationFK_EstoqueLocalizacao_LocalArmazenagem" msprop:Generator_UserChildTable="EstoqueLocalizacao" msprop:Generator_UserParentTable="LocalArmazenagem" msprop:Generator_ParentPropName="LocalArmazenagemRow" msprop:Generator_ChildPropName="GetEstoqueLocalizacaoRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>